DataBase - How to Link to Sql 2008 Table from Access Database

Asked By Lisa Tortorelli

13-Oct-09 04:08 PM

How do I Link to Sql 2008 Table from Access Database?  I need to send a file from Access into Sql Table so I can write directly to it.

thanx.



EggHeadCafe - Software Developer Portal of Choice
In-Memory Data Caching for Performance
http://www.eggheadcafe.com/tutorials/aspnet/c924e9aa-9085-41b3-9821-e5008e6123d0/inmemory-data-caching-fo.aspx

13-Oct-09 06:12 PM

Lisa

I am not aware of a "send a file" function in Access.  Are you saying that
you have data in an Access table you want to have in a SQL-Server table?

Which version of Access are you using?

Have you created a DSN (data source name) to manage the connection between
Access and SQLServer?

Regards

Jeff Boyce
Microsoft Access MVP


--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.