Importing creating blank record

[oilman]

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

[Lee Smith]

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

HTH

Lee

[oilman]

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

[Ugo DI LUCA]

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

[Lee Smith]

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

[danjacoby]

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.

[oilman]

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