terrible question?

[justin_ltg]

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

[OldPro]

On Sep 13, 3:09 pm, [e-mail] 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?

[AnandaSim]

On Sep 14, 6:09 am, [e-mail] 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'

[Tom van Stiphout]

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