Importing Error

[phong919]

Hello all,

I'm fairly new at access and have been stumped at this problem.

I download a csv file from the internet and what i wanted to do is just imported straight to a table from access. Some how the csv file contain some excel function that looks like the follwoing - i.e. =T("SOME TEXT"). Access can't import the file and i'm unsure of how i can do it. Does anyone have an idea of how i can do an import? Thank you.

 

[Ziggy1]

Open it in Excel clean up the data and format data types accordingly. You can do a copy>Paste special-values to strip out the formulas from the columns. Then save as a Excel (.xls) file. You can then import the Excel file into Access.

If you still have problems open the excel file and copy out the data range (not whole sheet), to a new workbook. Just in case there is garbage data off to the side that you can't see.