abdullauthan
Programmer
What is the fastest way to append records from a table in an Access database to another in a different access database? Is it possible with 'Select * Into ...." SQL statement?
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!
Appending from One Table to another
- Thread starter abdullauthan
- Start date
- Status
Hi Addulah,<br><br>Yes, I think you're on the right track with your select...into statement.<br><br>One thing occurs to me. If the two tables don't have the same fields you can't just say select * -- you have to give a field list.<br><br>Have a look at the Access forum if you get into difficulties.<br> <p>Mike<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href= Cargill's Corporate Web Site</a><br>Please don't send me email questions without posting them in Tek-Tips as well. Better yet -- Post the question in Tek-Tips and send me a note saying "Have a look at so-and-so in the thingy forum would you?" My home email is michael.j.lacey@ntlworld.com<
- Status
