Loading Microsoft access file via toad import option (import table data)

Toad for Oracle
1

Sir,

Can some one answer to the question on how to load MS ACCESS file in to a oracle table using the toad import option .

see my approach below:-

1.) created table to load access file

2.) selected access file from my local drive(.MDB file)

here is the issue I am facing … I am getting below message ? I already created the table with the same structure as access file ?

A TABLE NAME MUST BE PROVIDED .

NEED HELP to RESOLVE THIS ISSUE ?

Any one’s help is really appreciated .

2

Your screen shots didn’t come though, so I’m not sure what the problem is. You can email them to me directly if you can’t get them to appear here. john.dorlon@quest.com

3

Oh, now I see “A table name must be provided”. In the “Import Table Data” dialog, did you choose a table from the Access file? (Right under where the file name is specified)

4

table name is not listing in the drop down (Right under where the file name is specified)

5

Hmmm. So when you click that drop-down arrow, it’s empty? This is where you specify the Access table (there can be more than one of them in a file).

If there are no tables listed there, that’s a bug. Can you send me your access file so I can try to determine what’s wrong?

6

I sent sample ms access file in email . please take a look

thanks

7

OK ..please find the attached access file which i am trying to load .

thanks

Sreenivas

On Tue, Aug 4, 2015 at 5:07 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:

RE: Loading Microsoft access file via toad import option (import table data)

Reply by John Dorlon
Hmmm. So when you click that drop-down arrow, it's empty? This is where you specify the Access table (there can be more than one of them in a file).

If there are no tables listed there, that's a bug. Can you send me your access file so I can try to determine what's wrong?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.