Group:  Microsoft Access ยป microsoft.public.access.externaldata
Thread: TransferSpreadsheet Type Conversion Failure

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

TransferSpreadsheet Type Conversion Failure
jjgray 28.07.2006 16:01:02
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.

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net