Have you tried using
File | Import Records | File ?
I read your post as you having trouble exporting and then importing the records. You should be able to open the master file and use the above tool to import the records in one operation.
Yes I have done that. It gets thorugh to the match the fields screen and I match the fields and then try and import and it skips all the records and doesn't give a reason why. I have tried this in multiple formats and the files seem ok on Excel I just can't seem to get them to import into the Master FMP database.
Exporting seems to be ok its just the Importing thats at issue.
Any other ideas?
Import Records is a tool that has a lot of different options.
A couple of possibilities:
When you tried to use Import Records, did you have the source file open with the desired records in the found set? If the file is open it imports the found set, and if by any chance you have a found set of zero records, you'll get zero records imported. If the file is not open when you start to import, you should get the entire table.
When you use Import Records, are you selecting "Add New Records" as the import action or one of the "Update" options?
If none of this applies, I'd try recovering your target file and see if that changes anything.