transfer data from Excel to Access

[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

 

[Frank Kabel]

Hi
in Access:
File - Import External Data

 

[Jamie Collins]

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

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.

--

 

[Merlin Zener]

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

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.