barry 50045 (6/20/2014)
using t-sql, where and how would the connection to the access db be? Is there any way you could give me an example? Please believe me, I'm not asking you to spent a bunch of time to create an elaborate example just a simple one to get me started. As I said before, I had no idea you could do this in via t-sql.
In your web application you would have a database connection to your sql server AND a database connection to your Access database. Then you need to write create table statements and execute them against your Access connection. Then you write your insert statements the same way. It is not going to be pretty and will take a mountain of code but you can do it. You have to remember that Access is just a DBMS and you can write create table scripts and insert statements nearly identical to sql server syntax.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/