By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,694 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

terrible question?

P: n/a
I have an access db that contains lots of data. I have a software
package (want it) that will email out commission statements from the
data that is in access.

The catch? The data has to be in SQL format. MSDE or something of
the sort. Can I link the SQL DB to the Access data? I know you can
do it the other way around, but am unsure of this way.

thanks for any help
Justin

Sep 13 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Sep 13, 3:09 pm, justin_...@yahoo.com wrote:
I have an access db that contains lots of data. I have a software
package (want it) that will email out commission statements from the
data that is in access.

The catch? The data has to be in SQL format. MSDE or something of
the sort. Can I link the SQL DB to the Access data? I know you can
do it the other way around, but am unsure of this way.

thanks for any help
Justin
Can a SQL database fit as an attachment to an email? How does this
make sense?

Sep 13 '07 #2

P: n/a
On Sep 14, 6:09 am, justin_...@yahoo.com wrote:
I have an access db that contains lots of data. I have a software
package (want it) that will email out commission statements from the
data that is in access.

The catch? The data has to be in SQL format. MSDE or something of
the sort. Can I link the SQL DB to the Access data? I know you can
do it the other way around, but am unsure of this way.

thanks for any help
Justin
What does you mean by "SQL Format"? Do you mean that the database
engine must be SQL Server because the software package has only SQL
Server drivers / SQL Server syntax hard coded?

You can use an Access database and attach SQL Server tables.
Conversely you can use SQL Server and attach Access tables. A snippet
from help doco is thus:

sp_addlinkedserver 'Nwind', 'Access', 'Microsoft.Jet.OLEDB.4.0', 'c:
\mydata\Nwind.mdb'

Sep 13 '07 #3

P: n/a
On Thu, 13 Sep 2007 13:09:13 -0700, ju********@yahoo.com wrote:

Isn't that a question for the vendor of that package?

Yes, you can create an Access db as a "Linked Server" in Sql Server.

-Tom.

>I have an access db that contains lots of data. I have a software
package (want it) that will email out commission statements from the
data that is in access.

The catch? The data has to be in SQL format. MSDE or something of
the sort. Can I link the SQL DB to the Access data? I know you can
do it the other way around, but am unsure of this way.

thanks for any help
Justin
Sep 14 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.