Importing a CSV fiile

  • Thread starter Thread starter Igor T
  • Start date Start date
I

Igor T

Hi

I'm importing a CSV file. When I'm done importing it, all
text formated values have double quotes around them.

like
Period Name amount
"Jun" "Hommer" 10.34

I dont' want these quotation marks.
How do I get rid of them and prevent Access to add these
when importing?

Thanks
Igor
 
Hi Igor

Change file name extension to .txt and then import. In the import wizards you should be able to define this

Bernd
 
You must log in or register to reply here.

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

Convert a csv to xls prior to import 2
Record limit CSV import and more - Access 2002 SP3 1
Help, how do I import a CSV file when Negatives are in Parenthesis 3
Differences Between Two Spreadsheets ? 1
Forcing Excel to Import .CSV data 2
Importing csv files 1
Excel is stripping off quotation marks from .csv files if 5
Format of CSV file not preserved when edited in Excel 2007 1

Back
Top