| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Access, Paste data to table, and close all from Excel Macro
I have a macro that i have written to pull information in and format it from
a .txt file. I want to add code to the existing macro that will open an existing Access database, open a table within that database, and paste the data that has been copied from the excel file. I have been searching but there is so much information to sift through it is a little cumbersome. Any help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Access, Paste data to table, and close all from Excel Macro
I do not know how to control Access via Excel. I usually just pushed my data
into an excel sheet and run the following macro in Access. Sub tr9418() DoCmd.TransferSpreadsheet acImport, , "tr9418", "c:\feb2006\test4access.xls", True End Sub "learningaccess" wrote: I have a macro that i have written to pull information in and format it from a .txt file. I want to add code to the existing macro that will open an existing Access database, open a table within that database, and paste the data that has been copied from the excel file. I have been searching but there is so much information to sift through it is a little cumbersome. Any help would be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Access, Paste data to table, and close all from Excel Mac
Does that overwrite existing data that is in the table in the database? I
only want to add the new information to what is already there. Thanks "fugazi48" wrote: I do not know how to control Access via Excel. I usually just pushed my data into an excel sheet and run the following macro in Access. Sub tr9418() DoCmd.TransferSpreadsheet acImport, , "tr9418", "c:\feb2006\test4access.xls", True End Sub "learningaccess" wrote: I have a macro that i have written to pull information in and format it from a .txt file. I want to add code to the existing macro that will open an existing Access database, open a table within that database, and paste the data that has been copied from the excel file. I have been searching but there is so much information to sift through it is a little cumbersome. Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open book, copy and paste from sheet, and then close.... | Excel Programming | |||
| Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
| Open an Access table in Excel | Excel Discussion (Misc queries) | |||
| Macro to open and close an Excel file | Excel Programming | |||
| How do I Append excel data to a Access database table in a excel macro? | Excel Programming | |||
Linear Mode
