Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfer Data from Excel 2000 to the Access data base
How to have a macro in which I could register The path of the wanted data
base and the parameters I need to configur the transfer operation to MS Acces I tried to record the macro, I use Data/convert to MS Acces then the wizard ask me to convert to a new data base or an existing one . If i chose to an existing one I have to write the path of the Acces data base to wich I want to put Excel datas. Doing this, Excel opens Access Application and next steps are kept in charge, I suppose, by the Access application Wizard because it asks me to : 1- indicate if first line contain titles of columns (then press next) 2- indicate where to put data in a new table or an existing one (then press next) 3-- 4-- then to let acces add à primary key 5- indicate the table name to where i want data to be stocked and then Terminate the importation The macro I would like to build should replace by code actions 1 to 5 the wishard needs to transfer Datas from Excel 2000 to the Access data base selected (path). Thanks A. Lavoie, Québec, Canada |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfer Data from Excel 2000 to the Access data base
For a better (more controlled) way to send your data to Access, search this
newsgroup for the following: "Use ADO to add or update date in Access" Read the message thread for a response to a similar issue -- - K Dales "André Lavoie" wrote: How to have a macro in which I could register The path of the wanted data base and the parameters I need to configur the transfer operation to MS Acces I tried to record the macro, I use Data/convert to MS Acces then the wizard ask me to convert to a new data base or an existing one . If i chose to an existing one I have to write the path of the Acces data base to wich I want to put Excel datas. Doing this, Excel opens Access Application and next steps are kept in charge, I suppose, by the Access application Wizard because it asks me to : 1- indicate if first line contain titles of columns (then press next) 2- indicate where to put data in a new table or an existing one (then press next) 3-- 4-- then to let acces add Ã* primary key 5- indicate the table name to where i want data to be stocked and then Terminate the importation The macro I would like to build should replace by code actions 1 to 5 the wishard needs to transfer Datas from Excel 2000 to the Access data base selected (path). Thanks A. Lavoie, Québec, Canada |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to transfer a data base file into Excel then do mail merge | Excel Discussion (Misc queries) | |||
Transfer data from Excel to Access | Excel Discussion (Misc queries) | |||
2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do) | Excel Programming | |||
How to Transfer data from Excel to SQL SERVER 2000 | Excel Discussion (Misc queries) | |||
Transfer of data from excel to access | Excel Programming |