How Toad import from access database

Asked By Heather Abreu 40 points N/A Posted on - 10/30/2012

Hi ,

I'm using TMG 2010 SP2 and i want to allow block Dropbox. To work with TMG Server, Can any one please help me on this issue about tmg 2010 block.

• Status: Open
• Question Views: 1535
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Ihtavrap Noemi 5 points N/A #143092

How Toad import from access database

Well Mr. Abreu,

It’s a real tricky work plane for us because there is no straight way for that but you can try as following:

1. In Access database you can expert your table data in Delimited .TXT extension then save it.

2. Create a Same table header only for TOAD and export in TXT.

3. Then replace the head structure with your delimited output from Access DB. (Do it in another TXT file).

4. Now you can easily import the .txt in TOAD.

Hope you got it.

Thanks.

About Ihtavrap Noemi

Questions
4

Answers
104

Best Answers
19

• Vote Up 0 Vote Down

• Posted on - 11/08/2012
• Question Category: MS Access