ADO.NET Connection Strings

ODBC Driver for Excel

strConnection = _T(“Driver={Microsoft Excel Driver (*.xls)};DriverId=790;” bq=C:\\DatabasePath\\DBSpreadSheet.xls;

DefaultDir=c:\\databasepath;”);

ODBC Driver for Text
strConnection = _T(“Driver={Microsoft Text Driver (*.txt; *.csv)};” “Dbq=C:\\DatabasePath\\;Extensions=asc,csv,tab,txt;”);

Refer Connectionstrings

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: