Importing a spreadsheet but need to find and replace cells first

[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??

 

[pietlinden]

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??

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]