 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / May 2006Import a spreadsheet using a macro in access?
Hi, Is it possible to run a macro that imports an excel s/s into access without having to go through the "Import spreadsheet wizard"? Thanks George See TransferSpreadsheet action in the macro.  SignatureKen Snell <MS ACCESS MVP> > Hi, > Is it possible to run a macro that imports an excel s/s into access > without > having to go through the "Import spreadsheet wizard"? > Thanks > George Thanks very much Ken, Now i have the problem that the new file i upload is appending the old file. I do not wish to keep the old data.How do i replace the existing table with the new uploaded one? Thanks George > See TransferSpreadsheet action in the macro. > [quoted text clipped - 4 lines] > > Thanks > > George Delete the table in a macro action before the TransferSpreadsheet action. Or, to avoid database bloat, just run a delete query as the first action in order to delete the data from the table, then run the TransferSpreadsheet action. SignatureKen Snell <MS ACCESS MVP> > Thanks very much Ken, > Now i have the problem that the new file i upload is appending the old [quoted text clipped - 13 lines] >> > Thanks >> > George very good thanks for that > Delete the table in a macro action before the TransferSpreadsheet action. > [quoted text clipped - 19 lines] > >> > Thanks > >> > George |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.