Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Question - MDE
- Thread starter 101287
- Start date
HarleyQuinn
Programmer
You could use something like:
YourTable would have the same fields as the table you're trying to copy from.
Hope this helps
HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
Code:
With DBEngine(0)(0)
.Execute "INSERT INTO YourTable SELECT * FROM C:\Test2002.MDE.YourMDETable"
End WithHope this helps
HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
- Status
Similar threads
- Locked
- Question