Numeric Field Overflow XLS Link

[Ste4en]

I have a linked spreadsheet. When I link the sheet I get no options to set the field type. The xls field formats are all General.

I get Numeric Field overflow errors.

If I change 2 of the columns in the xls sheet to Text everything works fine.

How can I get this automated, i.e so that the link process includes reading those columns as text. When I have linked before there is usually a step where you can be more speficic about what is imported (maybe that is only a txt file.)

thanks

 

[Ste4en]

thanks

 

[iidx036]

I also had this problem with links to excel spreadsheets and sometime I rec'd the error and sometimes I didn't. After a while of trying to replicate it it some manner I gave up and ran a repair on the database the a compact. And I haven't had it since.

HTH