transfer data from Excel to Access

  • Thread starter Thread starter L.J.
  • Start date Start date
L

L.J.

I am not sure if this is the right group for me to ask the following
question, if not would you please direct me to the right group. Thanks!

Question: Is there any easy way to transfer data from Excel 2002 into Access
2002?

Regards,
LJ
 
L.J. said:
Question: Is there any easy way to transfer data from Excel 2002 into Access
2002?
Click to expand...

The following would work on either side i.e. client (pushing data to
Jet) or server (pulling data from Excel):

For an existing table:

INSERT INTO
[Database=C:\MyJetDB.mdb;].MyExistingTable
(Col1)
SELECT
MyCol AS Col1
FROM
[Excel 8.0;HDR=Yes;Database=C:\MyWorkbook.xls;].[MyWorksheet$]
;

To create a new table:

SELECT
MyCol
INTO
[Database=C:\MyJetDB.mdb;].MyNewTable
FROM
[Excel 8.0;HDR=Yes;Database=C:\MyWorkbook.xls;].[MyWorksheet$]
;

Jamie.

--
 
I am not sure if this is the right group for me to ask the following
question, if not would you please direct me to the right group. Thanks!

Question: Is there any easy way to transfer data from Excel 2002 into
Access 2002?

Regards,
LJ
Click to expand...

I don't have 2002 [I'm still using 2000] but last time I did it IIRC you
go to "File' then "Get External Data" then "Import" then select files of
type: Excel and choose your spreadsheet. A wizard will then start letting
you choose which sheets/columns etc.

HTH.
 
Back
Top