Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert Excel data to Access
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Access Database to Excel? | New Users to Excel | |||
Convert Excel 2007 data forms to Access 2007 ? | Excel Discussion (Misc queries) | |||
Convert MS Excel data to MS Access database | Excel Worksheet Functions | |||
Excel - Convert to MS Access | Excel Discussion (Misc queries) | |||
Excel's Marco Convert data to Access | Excel Programming |