docmd.transferspreadsheet

  • Thread starter Thread starter Darryl
  • Start date Start date
D

Darryl

Greetings,
I am using Access 2000. I have a spreadsheet in Excel. One of the columns
is zip codes.
Some of the cells in this column have 5 digit zip codes and some are the
extended ie xxxxx-xxx.

I have the docmd.transferspreadsheet on the on click event of a button on a
form.
When the transferspreadsheet runs, it generates an error table that contains
every extended
formatted zip code as an error. ie Sheet1$_importerrors. The error listed
is Type conversion failure.

Column is general in spreadsheet. field in table is text.

Any ideas ?

thanks,
Darryl
 
If possible, try putting an item with an extended zipcode within the first
10 or so rows of the spreadsheet.
 
Well, the first row to have one of these zip codes was row 10. I moved it
to row 1. Was able to import into the table without error.

It would be nice to handle this programatically so the user doesn't have to
edit
the Excel spreadsheet prior to running my form.

Any ideas on how to handle this programatically ?

thanks,
Darryl
 
Back
Top