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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL to Access question

Status
Not open for further replies.

JeremyAnderson

Technical User
Nov 4, 2005
16
US
I am attempting to pull data from a remote SQL server and filter it to append certain records to differant tables in a local Microsoft Access database. Anyone know how to do this?
 
If you have the odbc link setup correctly then as far as I know it should just be like working normally with access and vba.
create the table.
append records to that table.


Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top