Importing a spreadsheet but need to find and replace cells first

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

I have a spreadsheet that I need to open and replace all commas with a space,
then import into my database.
Is there a way I can import the spreadsheet and somehow replace the commas
before it gets imported into the table??
 
I have a spreadsheet that I need to open and replace all commas with a space,
then import into my database.
Is there a way I can import the spreadsheet and somehow replace the commas
before it gets imported into the table??
Click to expand...

create a query against the table, do your text manipulations in new
expressions and then import those expressions.
TestReplace: Replace([Name],","," ")
....replaces all instances of [comma] with [space]
 
Back
Top