Jump to content

Import matching from Excel problem


RedRock
 Share

This topic is 5645 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi Folks,

I hope somebody may be able to offer some suggestions on a weird problem I am having.

I am doing an import of a 5000 row excel spreadsheet into FM8 and are importing based on matching rows based on one key field. The import seems to work fine, but the resulting data in FM shows some weird symbols in the first field of the row on records that aren't supposed to have anything in that field, but these records do match the key field.

Symbols such as #N/A, and random characters seem to appear.

I am doing other imports and they work fine. It only seems to be when I am doing an import that uses the matching function. I have even tried clearing these fields in the spreadsheet prior to import, and changing character sets etc.

Any suggestions would be much appreciated.

Thanks

Paul

Link to comment
Share on other sites

My advice is to first open the Excel file in FMP and let FMP convert it into a database. Then massage the data in the intermediate file to clean it up. When done, import it into the main database.

Link to comment
Share on other sites

This topic is 5645 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.