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?
revolutionAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

weedCommented:
You dont have to select any fields. Just open the database, and file->export.
lesouefCommented:
Sorry to remind a basic rule, export exports only "found" records; are you sure they were all found before exporting?
If yes, must be a corrupted base, try to recover itn and try again

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PotzUKCommented:
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
PotzUKCommented:
Lesouef's point here is still my best guess at a solution for the OP's problem.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.