Link to home
Start Free TrialLog in
Avatar of Opusretis
OpusretisFlag for Switzerland

asked on

ODCB Datasource no driver for csv, excel, access

We've got a Terminal Server (Windows Server 2008 R2 64 bit )
For Database imports we need to have some ODBC Drivers for txt, csv, excel and access.
Unfortunately I can't find any ohter drivers then the SQL Server drivers.
From where can I get the other drivers and how can I install them?

Avatar of ewkelly
ewkelly
Flag of Canada image

Usually you go to the control panel and choose ODBC and then choose add. You should get a list of drivers to add.
ASKER CERTIFIED SOLUTION
Avatar of ewkelly
ewkelly
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Anthony Perkins
Unfortunately there are none available for you.
There are 1001 workarounds using 32-bit drivers, but there are no 64-bit JET drivers.
Avatar of Opusretis

ASKER

Is there realy no text driver for 64bit?
I understand the problem with office apps but csv or text should be supported
What exactly are you doing?  Have you considered using SSIS or BCP?
not of all.

It is a third party software with the functionality to import data into the tables.
Then I am afraid I have no idea.  Your best bet would be to contact them for a solution.