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

 

[Pat Hartman]

Unfortuantely the wizard doesn't give us a field type choice when linking a spreadsheet. I see two possible solutions, neither optimal.
1. Use automation to change the field type in the spreadsheet before you link to it. Don't ask me for code. You'll need to research this in Excel help. You can find general automation examples in the Microsoft kb.
2. Create a table with the columns formatted properly. Append to that table rather than link.

 

[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