T
Tron[ADS]
Can I do the following from within vb.net, automating an Access Database.
1. Open Database A
2. Import all tables from database B
3. Close.
Breaking down "2"..... If I were in Access, it would be :
File, Get External Data - Import, Select File B, click Select All, OK.
If I could do this process by Automation, it would save me a lot of
time.....Is it possible ?
I got as far as opening File A, but looking at all the available methods for
an Access Automation Object, I cannot see anything that comes close to what
I want to do.
Any advice gratefuly received.
1. Open Database A
2. Import all tables from database B
3. Close.
Breaking down "2"..... If I were in Access, it would be :
File, Get External Data - Import, Select File B, click Select All, OK.
If I could do this process by Automation, it would save me a lot of
time.....Is it possible ?
I got as far as opening File A, but looking at all the available methods for
an Access Automation Object, I cannot see anything that comes close to what
I want to do.
Any advice gratefuly received.