Is it possible to access MS Access tables from SQL S7? I do not have a database on SQL S7 and as such cannot create tables or even import tables from external sources (IT policies !!). As such I was wondering if you can connect directly to MS Access and query the data held within said database through SQL S7?
Thanks Guys and Gals.....Create link tables to the SQL db via ODBC. Then you can just code any connection to a listbox as usual (i.e. thru a table).
And use Books online as a resource to create linked server to MS Access.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment