Search results

Same results I got. Editing the CSV before hand is not an option. I mean it is, but not what I want. After importing to a “staging table” how to I run an INSERT to the table that contains the headers I want? Thanks for your info ps.

Did you set headers in the table prior to importing though? It imports fine if you don't put headers in the access table. But I need to label headers in the table first and then import.

CSV files can't be uploaded but here is a super basic version in excel format though.

I am searched long and hard trying to find an answer to this and I have not. - Importing .csv file via form button - I do not want to edit the source file prior to importing - Source file does not have headers I have tried changing the code to include and not include headers and neither works...

Hi, I am a relatively new user to Access! Within the past month I have been teaching myself during my downtime at work, in relation to a project that I am wanting to get off the ground for us to be able to use. I am not foreign to technology at all but have just scratched the service as far as...