Hi, I need some VBA code to import a table from one access database to another access database. Is this even possible using VBA? I already have code to bring data from access to excel and vise versa. Thanks!
I do want to copy the database because I need to have one live version and one static version of the tables. A few people will be needing to copy multiple tables over and I think the only way to prevent mistakes is if they can hit a button in excel.
I was reading a little about the docmd. command and I am not sure if my computer is up-to-date enough to use the command. I am still using Microsoft Excel 2003 and am unfamiliar with Visual C#. I'm sorry I didn't mention that before.
I am using db. and conn. connections to connect to access:
Dim Conn As New ADODB.Connection
Con.ConnectionString = DBlocation + AccessFile
Con.Provider = "Microsoft.Jet.OLEDB.4.0"
Dim db As Database
Set db = OpenDatabase(DBlocation + AccessFile)
db.TableDefs.Delete "Ovations_data_inccap_" + LOB
If I can use the docmd. with Excel 2003 please let me know and I will dig a little more. Thank you for your help!