When I import records from one db to another, FM6 creates an extra blank record in the main db so that ever other record is blank. Is there a way of not creating the blank record. The import is done by a running an script. Tried the import manully but still get the same results.

Thanks

Lionel

Every carrage return equals a new record. Be sure that there are none between records.

HTH

Lee

Hi Lee

I am sorry but i do not understand about the carrage return.

there is none in the script and the record is also created if the import is done manually.

Thanks

Lionel

Make sure the total record(s) found(s) = 0 before you start your import.

Hi Lionel,

I could be wrong, but I assumed this was an import of a text file. If so, open your file in a text editor, and you will probably see two returns between each record.

If this isn't the problem, send a small sample of what your file looks like that you are importing, along with your response, and I can help try to help you further.

HTH

Lee

1) How many records are in the file before you do the import? When you create a new file, it automatically starts with one blank record.

2) What are you importing from? Another FMP DB, or an Excel spreadsheet, or what? That could help with diagnosis.

hi all

thanks for all the insights but we have figure out the problem. By finding this one, we have come up with another one. Someone created a blank record and did not update the main db. We import one record at a time. We use a tab interface systems to fill out the form. The form is quite lengthy and we find that it is easier this way. But someone managed to by pass the validation system. Thanks for all your suggestion.

Lionel