IMPORTING Data from EXCEL file to existing ACCESS table

[Guest]

guys,

i want to IMPORT my files from excel to my existing table. I tried to use
the Import Spreadsheet Wizard but the field where I can store the excel file
to the existing table is ENABLED.

what should i do?

tnx...

Marc

 

[Stefan Hoffmann]

hi,

i want to IMPORT my files from excel to my existing table. I tried to use
the Import Spreadsheet Wizard but the field where I can store the excel file
to the existing table is ENABLED.
what should i do?

First of all, import your data not directly into your working table.
This can be done by:

- DoCmd.TransferSpreadsheet:
Needs some coding.

- use a linked table to your spread sheet

- use a query on your spread sheet
Create a query with a SQL like that:

SELECT *
FROM [Excel 8.0;Database=PathToYourExcel;Hdr=Yes].[SheetName$]


mfG
--> stefan <--

 

[Guest]

so, il do do these by creating a new form and codes....right?
thought i can just import excel file using the importing wizard...

thanks...

hi,

i want to IMPORT my files from excel to my existing table. I tried to use
the Import Spreadsheet Wizard but the field where I can store the excel file
to the existing table is ENABLED.
what should i do?

First of all, import your data not directly into your working table.
This can be done by:

- DoCmd.TransferSpreadsheet:
Needs some coding.

- use a linked table to your spread sheet

- use a query on your spread sheet
Create a query with a SQL like that:

SELECT *
FROM [Excel 8.0;Database=PathToYourExcel;Hdr=Yes].[SheetName$]


mfG
--> stefan <--