https://bugs.freedesktop.org/show_bug.cgi?id=43298
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|MinGW FILEOPEN cannot open |MinGW FILEOPEN hang instead |MS Access (.mdb) files |of error message when using | |ADO --- Comment #7 from Lionel Elie Mamane <[email protected]> 2011-11-29 01:30:13 PST --- After more tests: - It hangs in MinGW build when MSVC build gives error message. - It works in MinGW build when it works in MSVC build: .mdb files, .csv/txt/tab files, ... Adjusting bug summary appropriately. My connection string for a CSV file was just wrong. The primary error was that one needs to put the path to the DIRECTORY where the file resides, and not to the file itself... Each file is then one table. Also, the HDR=.. and FMT=.. need to be *within* the 'Extended Properties', not outside of it, like in: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\path\to\directory\;Extended Properties="text;HDR=Yes;FMT=Delimited;"; Then there is the nitpicking about what the separator is (tab? comma? semicolon?), which I could only solve by creating a schema.ini file, the FMT=... does not seem to have any effect. References for using Jet through ADO to connect to text files: http://msdn.microsoft.com/en-us/library/ms974559.aspx http://www.codeproject.com/KB/database/ReadTextFile.aspx http://www.codeproject.com/KB/cs/UsingJetForImport.aspx Example of a schema.ini file: [data.tab] Format=TabDelimited [data.txt] Format=Delimited(;) -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
