revolution
asked on
Advice exporting to a file
Hi all
I've got a Filemaker Pro 5.5 setup and a database with ~3000 records in it. I need to export the contents to a CSV for import into SQL server (no, I can't keep using Filemaker through a connector) but I'm having difficulty getting all of the records. Sounds crazy I know, but the first time I did an export, I got all 3000 records. I selected about 20 fields and it exported every record fine. When I select all of the fields and do export, I only got 480.
Can someone please help?
I've got a Filemaker Pro 5.5 setup and a database with ~3000 records in it. I need to export the contents to a CSV for import into SQL server (no, I can't keep using Filemaker through a connector) but I'm having difficulty getting all of the records. Sounds crazy I know, but the first time I did an export, I got all 3000 records. I selected about 20 fields and it exported every record fine. When I select all of the fields and do export, I only got 480.
Can someone please help?
You dont have to select any fields. Just open the database, and file->export.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just echoing what lesouef has said - if you want all the records in the export make sure you don't have a found set. Press Ctrl+J / Records -> Show All
Lesouef's point here is still my best guess at a solution for the OP's problem.