"Thaddeus" <Thaddeus@discussions.microsoft.com> wrote in message
news:4A63FE2F-EF83-4550-9B54-53C7F554E160@microsoft.com...
> 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.
>
>

"Thaddeus" <Thaddeus@discussions.microsoft.com> wrote in message
news:707BD6F5-8A33-43B3-9377-0E8757044990@microsoft.com...
> Hi Allan,
> Nope. I am trying to import using EM instead of writing codes.
> But
> thanks.
> --
> With Thanks,
> Thad
>
>
> "Allan Mitchell" wrote:
>
>> 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@discussions.microsoft.com> wrote in message
>> news:4A63FE2F-EF83-4550-9B54-53C7F554E160@microsoft.com...
>> > 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.
>> >
>> >
>>
>>
>>