All Forums Tools
Renji 17 posts Joined 08/05
25 Sep 2012
Fast Export into a Access .mdb format

Hello .. We are using Teradata 13. I have a requirement to generate multiple .mdb files from two Teradata tables on a monthly basis. The tables are being built by an automated process, and the .mdb generation is expected to be part of the process. On a manual mode, we can use Teradata SQL Assistant --> Export results --> Execute --> Save as Type, and choose .mdb or .txt or .csv or something, and this is very straight forward. I am trying to do the same in a batch mode. I have to create various .mdb files from the above automated task. Is there a way to do this using bteq or fexp ? Or do I need to write the data to a .csv and then export to MS Access ?? Thanks in advance

Regards John Abraham
VandeBergB 182 posts Joined 09/06
25 Sep 2012

Why not use Access to query the data?  Pull it from Access rather than "pushing" from TD.

Some drink from the fountain of knowledge, others just gargle.

Renji 17 posts Joined 08/05
25 Sep 2012

Thanks for the input, but, the need is to create an .mdb which needs to be FTP'd somewhere. We dont even need to open up the file. We are trying to automate an existing manual process, which involves multiple groups and parties, so trying not to make any format changes, as much as possible. If not, it would have been much easier for us to create a .txt file zip it and send it out.

Regards
John Abraham

SuSeSi 61 posts Joined 10/08
26 Sep 2012

Teradata OLE DB Access Module can be used here. Go through the "Teradata Access Module Reference" manual and set up a batch job, exporting data from Teradata Database using Fastexport to OLE DB Provider which will connect to Access database.
 

-Sudhansu

07 Jan 2013

I export the data to mdb using the manual method, but I need to automate the process to export the data directly to mdb format from teradata, please any body can guide me with the query logic.
Thanks in advance!!!

You must sign in to leave a comment.