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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Differences Between Two Spreadsheets ? 1
importing data 1
Transferspreadsheet import conflict 3
Automating a Find and Replace. 2
TransferSpreadsheet question 4
Excel Import External Data by Date Automatically 0
Help, how do I import a CSV file when Negatives are in Parenthesis 3

Back
Top