Import Excel spreadsheet...

[Guest]

I am having a problem importing an Excel spreadsheet into Access. The
columns that im having problems with contain product ID numbers... the ones
that I have a problem with have dashes in the order number. The import
wizard wont let me change the data type for this column... it is double.. but
I just want it to be Text.... any help is very much appreciated.

 

[tina]

go ahead and import once, to create the table. then delete the data from the
table, open the table in design view, and change the field's data type from
Number to Text. henceforth, use the TransferSpreadsheet action in a macro or
VBA to import the spreadsheet to the existing table.

hth

 

[Guest]

thanks tina.... I can do the first part... but VBA... or macros... I am lost
at doing... some more help please??

 

[tina]

in the database window, go to the Macros tab and create a new macro. in the
macro window, click in the Action column, it's a "droplist" field with all
the Actions listed in alphabetical order. scroll down to the
TransferSpreadsheet action and select it. in the bottom half of the macro
window is the Arguments section. click on the line for the first argument
and press F1. this takes you to the TransferSpreadsheet topic in Access
Help, so you can read about how the action works and how to correctly enter
each argument.

hth