I have a DBF file from an old application made for cataloging and labeling slides.
I have tried many methods to import the data into a format I can use but so far none have been successful. What has happened in most or all instances is that the data for all 2000+ records are imported into one cell in a spreadsheet.
Among what I've tried: Opening directly into Excel; converting the dbf file to txt and opening in Excel; using an online converter and attempting to convert to .csv and .xlsx; using Power Query.
The user database folder in the application has 20 files. Going by the Date modified, three files in that folder seem to be relevant: db.dbf, db.mdx, db.dbt. Opening the dbf file with Notepad, I can verify the data I want is present.
How can I get that data into Excel? Or, what other information do you need to address this issue?
Many thanks.
I have tried many methods to import the data into a format I can use but so far none have been successful. What has happened in most or all instances is that the data for all 2000+ records are imported into one cell in a spreadsheet.
Among what I've tried: Opening directly into Excel; converting the dbf file to txt and opening in Excel; using an online converter and attempting to convert to .csv and .xlsx; using Power Query.
The user database folder in the application has 20 files. Going by the Date modified, three files in that folder seem to be relevant: db.dbf, db.mdx, db.dbt. Opening the dbf file with Notepad, I can verify the data I want is present.
How can I get that data into Excel? Or, what other information do you need to address this issue?
Many thanks.