docmd.transferspreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darryl - 20 Oct 2005 20:50 GMT

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

Reply to this Message

MacDermott - 21 Oct 2005 02:22 GMT

If possible, try putting an item with an extended zipcode within the first
10 or so rows of the spreadsheet.

> Greetings,
> I am using Access 2000. I have a spreadsheet in Excel. One of the columns
[quoted text clipped - 15 lines]
> thanks,
> Darryl

Reply to this Message

Darryl - 21 Oct 2005 15:24 GMT

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

> If possible, try putting an item with an extended zipcode within the first
> 10 or so rows of the spreadsheet.
[quoted text clipped - 21 lines]
> > thanks,
> > Darryl

Reply to this Message