programmer2programmer.net
| | Tips | | Microsoft Certification | | Final Year Project Idea | | Connection Strings | | Password Recovery | | SQL Injection | | Encryption & Decryption | | | | LIVE Academic Project | | Project #1 - VB6, Access | | Project #2 - VB.Net, SQL | | Project #3 - ASP, Access | | Project #4 - ASP.NET, C# | | Project #5 - VB6, SQL | | Project #6 - Stegano | | Project #7 - C | | Project #8 - C++ | | Project #9 - JAVA, MySQL | | Project #10- PHP, MySQL | | Project #11- JSP, Oracle | | Project #12- C# Face Exp | | Project #13- Mobile Bank | | Download MBA Project | | MBA Project Topic | | Project Viva Question | |
2018 New Projects | | Project Synopsis Download | | | | University Question Paper, Assignment and Projects | | SMU - Question Paper | | SMU - Assignment | | SMU - Synopsis Projects | | SCDL - Assignment | | IGNOU - Synopsis Projects | | Welingkar - Projects | | Project Report Formats | | | | Interview Question Answer | | General & HR Round | | Visual Basic 6 | | VB.Net & C# | | ASP.Net | | SQL Server | |
Oracle and DBA | | My SQL | | |  | 100% Tested Ready Academic IT Projects | BE, ME, BTech, BCA, MCA, MBA, Bsc-IT, MS, BIT, ADIT, DOEACC, IGNOU, SMU | readymadeproject.com |
|
|
|
.TXT
and .CSV File Connection Strings for OLEDB, ODBC, Connection string
for text and csv file. |
|
|
Largest collection of
Connection Strings on
Internet for -
|
|
|
|
ODBC Connection
String for text and csv file. |
|
|
Standard Security |
|
|
|
Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;
|
|
|
|
oConn.Open _
"Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"Dbq=c:\somepath\;" & _
"Extensions=asc,csv,tab,txt"
Then specify the filename in the SQL statement:
oRs.Open "Select * From customer.csv", _
oConn, adOpenStatic, adLockReadOnly, adCmdText
Note: If you are using a Tab delimited file, then
make sure you create a schema.ini file, and include
the "Format=TabDelimited" option.
|
|
OLE
DB, OleDbConnection (.NET) Connection String for
text and csv file. |
|
|
Standard Security |
|
|
|
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended
Properties="text;HDR=Yes;FMT=Delimited";
|
|
|
|
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\;" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited"""
'Then open a recordset based on a select on the
actual file
oRs.Open "Select * From MyTextFile.txt", oConn, _
adOpenStatic, adLockReadOnly, adCmdText
|
|
|
Fixed length columns |
|
|
|
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended
Properties="text;HDR=Yes;FMT=Fixed";
|
|
|
|
|
|
|
|
Connection Strings
Main |
|
|
|
(C) Atanu Maity, 2006-2018
|