Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Appending to Access table
I would like to appended my excel data to a access database table. I
can manualy do this but I need to programmatly do it. I also must avoid the message "you are about to append ??? records". Thanks for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Appending to Access table
In Access...
1) Create a link to the workbook/worksheet you want to append data from 2) Create an append query. 3) Create a macro such as... 'stop warning messages DoCmd.SetWarnings False 'append query called "Query1" DoCmd.OpenQuery "Query1", acViewNormal, acEdit 'turn warning messages back on DoCmd.SetWarnings True HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Pete" wrote: I would like to appended my excel data to a access database table. I can manualy do this but I need to programmatly do it. I also must avoid the message "you are about to append ??? records". Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel appending to Access - no duplicates | Excel Discussion (Misc queries) | |||
Appending to Access table | Excel Programming | |||
Linking a table in Access to a table in Excel using MS Query | Excel Programming | |||
Appending records from one table to another | Excel Programming | |||
Appending Excel file to an Access table | Excel Programming |