Opusretis
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?
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Unfortunately there are none available for you.
There are 1001 workarounds using 32-bit drivers, but there are no 64-bit JET drivers.
ASKER
Is there realy no text driver for 64bit?
I understand the problem with office apps but csv or text should be supported
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?
ASKER
not of all.
It is a third party software with the functionality to import data into the tables.
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.