Link to home
Start Free TrialLog in
Avatar of revolution
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?
Avatar of weed
weed
Flag of United States of America image

You dont have to select any fields. Just open the database, and file->export.
ASKER CERTIFIED SOLUTION
Avatar of Member_2_908359
Member_2_908359
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.