exporting data into access

[Shaves]

I have an Excel workbook with several sheets. One of the sheets has 67 columns. I need to export this data into a table in Access. In the past, I have created an access object and used the transfer spreadsheet command. I'm wondering if there is a better or easier way to get the data into access?

Thanks for the help......

 

[SkipVought]

Hi,

A NEW table or an EXISTING table?

Skip,

_{I'll be dressed to the nines this week, as I go to have my prostatectomy...
Because, if I'm gonna BE impotent, I want to LOOK impotent!}

 

[Shaves]

It is an existing table

 

[JerryKlmns]

To get data into access using MSAccess enviroment, link the sheet, create a DELETE query if you like to get only current records and an APPEND query to import current records. Execute those queries as ordered.

 

[xlbo]

ADO with an APPEND query from excel is the way I would do it if it is a repeating task

If it is a one off then I would do as Jerry has suggested


Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question