| 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 | |||
Linear Mode
