This has been just such a pain with 64 bit! Data Access!! I have been unable to use linked servers from SQL server to access files because there is no Jet 64 bit. Now, I have been using bulk insert statements. These are working ok, but for some
uknown reason, for a certain .csv file I am getting unexpected end of line errors. I have tried many things to no resolution..
How can I get linked servers to work with SQL Server 64 bit for excel and access? Why would microsoft leave this out??
View Complete Post