Importing CSV File Issue.

[TallMan]

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!

 

[vbaInet]

Check the header names (i.e. the first row) and ensure that they don't contain invalid characters.

 

[TallMan]

Thank you for your help .

 

[vbaInet]

No problemo!

 

[The_Doc_Man]

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).