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!
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!
