Import Table without Relationship

[ishaqani]

I want to import tables from one mdb file to another mdb file without relationship using code. Anyone have the code?

Thanks.

 

[boblarson]

Go to the VBA help file and lookup DoCmd.TransferDatabase (you might have to just search on TransferDatabase).

 

[ishaqani]

can you give me exact code?

 

[boblarson]

Um, not trying to be "snooty" here but we do expect people to actually TRY to do their work instead of relying on us to spoonfeed them.

I gave you the code and if you even had BOTHERED to type it in to the VBA window, intellisense would kick in and give you all the information you need. And if that wasn't enough, you just have to hit F1 to bring up help while your cursor is in the word TransferDatabase.

And, the last is that if you type the command (without the period) as two words DoCmd TransferDatabase into the search function here you would find a post with that exact code.

See if you can't actually work it out for yourself because it will help you in the long run to know how to go find stuff like this.