My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Docmd.transferdatabase-import Tblfrom Ade ?, Office 2003
|
|
 Nov 2 2011, 06:11 PM
Post
#1
|
|
|
UtterAccess Certified! Posts: 6,942 From: Arizona, United States  |
Can I use access vba to import a table from an ADE ? I can copy/paste the ade table, into my MDB/MDE, so can I also use docmd.transferdatabase?
I'm getting this runtime error: [My database name] cannot find the object "|." CODE Sub test() DoCmd.TransferDatabase acImport, "Microsoft Access", "C:\Path\TheOtherDatabaseName.ade", acTable, _ "tablename", "tablename" End Sub PS - sorry, looks like I may have had the name wrong. Apparently the names look a lot different in an ADE and not always what they appear to be. This post has been edited by ipisors: Nov 2 2011, 06:13 PM |
 |
 
|
|
Nov 14 2011, 12:47 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 20,211 From: Colorado |
Hi Isaac,
are you sure that ADE is the right extension? MDE perhaps? or ACCDE? |
|
|
|
|
Nov 14 2011, 01:09 PM
Post
#3
|
|
|
UtterAccess Certified! Posts: 6,942 From: Arizona, United States |
It actually is an ADE, but eventually I solved it by realizing I actually had the name of the table wrong.
Apparently in an access project there are multiple different 'names' that can be apparent, such as the table name as shown in the object display, the table name as shown in the "add tables" dialogue when creating a query in QBE, and the table name that 'really exists'.......Once I got that right, the error went away and it worked. eventually i decided not to go this route, though......As I realized that importing an entire table with hundreds of thousands of records......Then deleting it........caused an insane amount of bloat and wasn't anywhere near worth the trouble! (IMG:style_emoticons/default/wink.gif) |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 25th May 2013 - 02:57 PM |