Recent content by DavidPhillips

I got something that works. Not sure if it is the best way but it will do for now. Instead of using a spec file I decided to read the header line from the first file imported and use that to create a table with all fields as text because the headers are all text. Private Sub...

Looking for a way to use transfertext to make a table and create a spec file from csv files I am importing. I want all fields in the table to be shorttext. Otherwise I need another way to bring the files into a table. Update: I have a generic spec to use that brings in any data as text...

The table you are importing into does not contain the fields you are importing. Try running without the table existing and it will be created.

Try adding a form restore before the command to hide the access window. Application.DoCmd.Restore