Hi all,
I am having problems importing data from Access 97 .mdb files into
my SQL Tables.
Using DTS, I invoked the Import/Export wizard.

When prompt for the source, I specified Microsoft Access and it's
path/filename.
I did not enter username and password for the source.

But when DTS executes the query to import data, it prompts me this error:
"Records cannot be read, no read permission on tablename"

When i entered the userid and password for the workgroup file(mdw),
it says that "cannot start application. Workgroup information file is
missing or open exclusively"

How can I work around this? Or Is there other way to import data into SQL
table? I tried to perform export from Access 97. It creates a new table in my
SQL Server instead, without keys, indexes, relationship.

Any thoughts/help greatky appreciated.

Does this article help at all ?


How can I dynamically set the Access System Database
(http://www.sqldts.com/default.aspx?241)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Thaddeus" <Thaddeus (AT) discussions (DOT) microsoft.com> wrote

Hi Allan,
Nope. I am trying to import using EM instead of writing codes. But
thanks.
--
With Thanks,
Thad


"Allan Mitchell" wrote:

This would still be in your package but OK so you do not want to write code
then you can find the information you need to specify on the Access
Connection and in Disconnected Edit.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Thaddeus" <Thaddeus (AT) discussions (DOT) microsoft.com> wrote