Sep-18-2022, 02:07 AM
(Sep-16-2022, 09:28 PM)rob101 Wrote:(Sep-16-2022, 10:43 AM)JonWayn Wrote: But then when I go to import this file into a Microsoft Access database, nothing is imported.
It's been a number of years since I worked with MS Access, but from what I can recall: make sure that the separator is set to comma, and not some other separator. Also, I think I remember a setting that tells Access if the first row contains the header information. If not, the table will be created with default header names, which you can, of course, edit, post import.
As I found out later, the same file imports ok in another table. So I deleted and recreated the failed table, thinking there might have been some corruption to it. I also created a linked table to the file, using a query to get the records into the table. Still empty. So one table is behaving differently from the other. So it is starting to look like a problem in Access and not the file contents. And yes, Access has the feature to specify that first row is headers