Opening through connection string interface: Thank you for your interest in this question. Thanks for this – I’m sure you’ll help others users in the future. Wednesday, July 22, Do any of you know what could be causing the T-SQL command to fail like this? Thursday, August 6, 9:

Uploader: Fet
Date Added: 8 December 2009
File Size: 45.15 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 31791
Price: Free* [*Free Regsitration Required]

The error you get seems to point at the driver itself msdasq, being recognized or not installed correctly rather than the file itself not being found. I think there are a couple problems.

When to use MSDASQL and when to use MSDASQL.1?

Wednesday, July 22, I’ve also msdasqk it on Windows Vista x32, same error. Has anyone successfully run this command on Win 7 x64?

I’ve just wrestled with this issue for several hours on a Win7 x64 machine, and it is so difficult to find a good answer online that I thought I’d contribute one to this thread belatedly. If someone posts about a vendor issue, allow the vendor or other customers to respond. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site the association bonus does not count.


If Msdassl can understand why there might be two or them then I might be able to work out the problem.

I’m sure if I reinstalled Win7 x64 it would start to work again. What are the numbers for and how are they assigned?

Therefore, they are essentially identical and can be used interchangably. Select ‘File’ option and then browse for the needed file.

If I execute the following command: By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. It works on an out-of-the-box Win7 x64 machine, but I still can’t fix this error on my machine.

Linked Server

Mine had just two words in it, separated by commas, e. I can vouch for that because I went through several wrong iterations.

msdazql Tuesday, May 4, 6: Developing Under Previous Versions of. Magee 1 3. I just now tried a file with only ‘ten,four’ in it and it worked.

FAQ: Why cannot 64-bit MSDASQL access a .csv text file?

Friday, July 24, 6: Here are basic connection strings more examples and details can be found in the Internet:. I ended up going with “bulk insert” to do the job, and it works brilliantly. Here are basic connection strings more examples and details can be found in the Internet: I’ll go with “bulk insert” see my comments below. I can see both variations here in the registry: Sign in to vote.


For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines: But first, you should create an ODBC DSN of the corresponding type using Windows administrative tools, and point it to the folder which contains needed files.

Opening Text and CSV Files – Exportizer Documentation

DNN Digest is our monthly email newsletter. What should I be looking for in the registry? Exportizer Users’ Guide vlsoftware. Thursday, July 23, 7: Opening through connection string interface: Contango 40k 48