convert Excel data to Access
 

Does anyone know how to convert excel spread sheet into
Access? the excel file have mulitple spread sheet. I am using the
marco to pick up the data from the sheet1 then output to sheet2, and
then calcurate the result to output to sheet3. How can I import those
data to access? I tried to use import data from external data in
Access, but it doesn't work. Any suggestions? Thanks

convert Excel data to Access
 

http://www.erlandsendata.no/english/...php?t=envbadac

Hth,
Merjet

convert Excel data to Access
 

You can create a "linked" table in Access linked to the spreadsheet. Then
create an "append" query that will take the data from the linked table and
place it in the table.
--
Best wishes,

Jim


" wrote:

Does anyone know how to convert excel spread sheet into
Access? the excel file have mulitple spread sheet. I am using the
marco to pick up the data from the sheet1 then output to sheet2, and
then calcurate the result to output to sheet3. How can I import those
data to access? I tried to use import data from external data in
Access, but it doesn't work. Any suggestions? Thanks