|
Home > Archive > MS SQL Server DTS > July 2005 > Importing MS Access data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Importing MS Access data
|
|
| Ghost Dog 2005-07-25, 8:29 pm |
| Is there a way to run a DTS package to import Access data when the MDB has
an associated MDW file? I have a valid username and password, but I can't
open the MDB within DTS . I can open the MDB, export the data to an
unprotected MDB, then import the data from that, but I'd rather use the root
file.
| |
| Darren Green 2005-07-26, 3:24 am |
| Why can you not open the MDB in DTS? I assume you get an error, and
supplying details does help.
Have you set the MDW in the advaned property "System database"?
You may also need to set it in the registry -
How To Use a SQL Server 7.0 Distributed Query with a Linked Server to
Secured Access Databases
(http://support.microsoft.com/defaul...kb;en-us;246255)
--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Ghost Dog" <caspar@friendly.com> wrote in message
news:%234i3GeVkFHA.3960@TK2MSFTNGP12.phx.gbl...
> Is there a way to run a DTS package to import Access data when the MDB has
> an associated MDW file? I have a valid username and password, but I can't
> open the MDB within DTS . I can open the MDB, export the data to an
> unprotected MDB, then import the data from that, but I'd rather use the
> root
> file.
>
>
| |
| Ghost Dog 2005-07-26, 8:24 pm |
| Thanks Darren, that works. I'm not an Access guy.
P.S. I didn't need to make a registry entry.
"Darren Green" <darren.green@reply-to-newsgroup-sqldts.com> wrote in message
news:uAlIIXbkFHA.576@tk2msftngp13.phx.gbl...
> Why can you not open the MDB in DTS? I assume you get an error, and
> supplying details does help.
>
> Have you set the MDW in the advaned property "System database"?
>
> You may also need to set it in the registry -
>
> How To Use a SQL Server 7.0 Distributed Query with a Linked Server to
> Secured Access Databases
> (http://support.microsoft.com/defaul...kb;en-us;246255)
>
>
> --
> Darren Green
> http://www.sqldts.com
> http://www.sqlis.com
>
>
> "Ghost Dog" <caspar@friendly.com> wrote in message
> news:%234i3GeVkFHA.3960@TK2MSFTNGP12.phx.gbl...
has[color=darkred]
can't[color=darkred]
>
>
|
|
|
|
|