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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert data Access 2007 to SQL 2008 table

Status
Not open for further replies.
barbola

barbola

Technical User
Feb 27, 2003
1,132
CA
I have an Access 2007 database query and I want to create a temporary table in a SQL 2008 database.

I know I need to connect to the server and database, I know I need my recordset from the query, and I need to use an Insert Into statement.

I can find bits and pieces of code but nothing complete to do what I want to do.

Does anyone have any ideas or sample code you can point me to please?
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
602
remeng
remeng
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
557
strongm
strongm
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
584
hermanlaksko
hermanlaksko
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
312
remeng
remeng
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
264
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top