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 SkipVought 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
0
0
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
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
145
strongm
strongm
Andrzejek
  • Question
Outlook VBA - Trust access
Replies
3
Views
219
hermanlaksko
hermanlaksko
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
132
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
90
strongm
strongm
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
140
feipezi
feipezi

Part and Inventory Search

Sponsor

Back
Top