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

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

Hth,
Merjet

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


"(E-Mail Removed)" 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
>
>