|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
When transfering .xls into Access table I get a Type Conversion Failure error after the transfer. Example: I have 1 worksheet with multiple columns in Excel. Some columns contain both numeric and text values. If the top row of the imported sheet is numeric and several rows down is Text in the same column the error occurs. If the top row is Text and everything below it is numeric the error does not occur. I have the Field Name's Data Type set to Text. Any assistance would be appreciated.
|
|
|