Importing CSV File Issue.

TallMan

Registered User.
Local time
Today, 10:11
Joined
Dec 5, 2008
Messages
239
Good Afternoon,

Our IT department is running a stored procedure every morning which wraite a very lengthy .csv file. (About 100,000 rows) I need to take this file and somehow get it into access. I have tried linking it so that I could eventually append it into a table with the same column headings.

I have tried appending straight from the server where the IT department is leaving it.

I have tried importing it as a table.

I am not having any luck. I keep getting this error.

" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

Any ideas? Thanks a bunch guys and gals!;)
 
Check the header names (i.e. the first row) and ensure that they don't contain invalid characters.
 
Thank you for your help .
 
Also watch out for headers that contain BLANKS embedded between legit name parts. When you use a name that contains a blank, you must enclose the name in quotes (when using a fielddef lookup) or square brackets (when doing an SQL reference).
 

Users who are viewing this thread

Back
Top Bottom