How to export data to MSACCESS (.accdb) file using Bteq

Database
Enthusiast

How to export data to MSACCESS (.accdb) file using Bteq

Hi ,

I need to export the data to the .accdb file by using bteq .

Any please suggest me how to export the data .

please help me
3 REPLIES
Enthusiast

Re: How to export data to MSACCESS (.accdb) file using Bteq

Why use BTEQ? That seems the wrong tool, considering that MS Access can connect to Teradata and get results back directly.
Enthusiast

Re: How to export data to MSACCESS (.accdb) file using Bteq

Its my requirement to export data to Msaccess ,so that Business users will validate it and upload the same to Database. as a developer i need to export tha data to MS access. If its not possible through ms access suggest me an alternative way to export data .
Enthusiast

Re: How to export data to MSACCESS (.accdb) file using Bteq

As I said, you can export from Teradata directly into MS Access. You don't need BTEQ to do that. As I understand it, you only need to point MS Access to your Teradata ODBC data source or .NET provider.