G Grey May 28, 2004 #1 how to read a csv file with OLEDB...can anyone provide the connectionstring?? Million thanks
G Guest May 28, 2004 #2 Hi Grey, how to read a csv file with OLEDB...can anyone provide the connectionstring?? Million thanks Click to expand... I found something like this: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties=""text;HDR=Yes;FMT=Delimited""" ("HDR=Yes;" indicates that the first row contains columnnames, not data) My sources: http://www.connectionstrings.com/ http://support.microsoft.com/defaul...s/Q262/5/37.ASP&NoWebContent=1&NoWebContent=1 http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm Cheers! Marcin
Hi Grey, how to read a csv file with OLEDB...can anyone provide the connectionstring?? Million thanks Click to expand... I found something like this: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties=""text;HDR=Yes;FMT=Delimited""" ("HDR=Yes;" indicates that the first row contains columnnames, not data) My sources: http://www.connectionstrings.com/ http://support.microsoft.com/defaul...s/Q262/5/37.ASP&NoWebContent=1&NoWebContent=1 http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm Cheers! Marcin
G Guest May 28, 2004 #3 That is very good information for me Thank you Jhin-Seok _________________________ Have a Good Day _________________________ Mail :[email protected] Mail2:[email protected] MSN :[email protected] Tel. :33-1-7142-640 _________________________ http://leehack.sarang.net
That is very good information for me Thank you Jhin-Seok _________________________ Have a Good Day _________________________ Mail :[email protected] Mail2:[email protected] MSN :[email protected] Tel. :33-1-7142-640 _________________________ http://leehack.sarang.net
