LOng Time NO SEEE ----------------------------- "I Think this Will Help" ----------------------------- Alok Gupta visit me at http://www.thisisalok.tk

Hi, thanks for reply. I am new to databases,so i am not able to implement your suggestion into code. I am sending my present code .It will be of great help,if you show me direction from here. CString sDriver; sDriver = _T("MICROSOFT ACCESS DRIVER (*.mdb)"); CString sDsn; sDsn.Format(_T("ODBC;DRIVER={%s};DSN='';DBQ=%s"),sDriver,sInstallDir + _T("\\v010\\Program\\MDD.mdb")); if(!m_pDatabase->IsOpen()) { m_pDatabase->Open(NULL,FALSE,FALSE,sDsn); } ............................................................. //HERE I NEED THE CODE TO CHECK WHETHER THE DATABASE HAS ANY TABLES ,IF YES ,I NEED TO DELETE THOSE TABLES. .............................................................. I DON'T KNOW HOW TO GET CONNECTION OBJECT HERE BECAUSE I DON'T FIND ANYTHING LIKE CONNECTION OBJECT WHILE USING ODBC,CDATABASE AND CRECORDSET CLASS. .................................................................... ANY HELP WILL BE GREATLY APPRICIATED. .......................................... THANKS AND REGARDS.

read msdn "SQLDriverConnect (Access)" there you will see, that the UID and PWD keywords are supported... use sDsn.Format(_T("ODBC;DRIVER={%s};DSN='';DBQ=%s;UID=%s;PWD=%s"),sDriver,sDatabase,sUser,sPass); i don't know if this works, it's just an idea. good luck Don't try it, just do it! ;-)

Or, the CRT function remove().  onwards and upwards...

you can view the contents of the dll in the OLE/COM Object Viewer the dll that you need will probably be in the type librarys part you can the open up the dll by double clicking on it, copy whats in there to the clipboard back in visual studio create a new idl file, paste in the contents of the clipboard, save the file. add this to your project and compile this will then generate the headers (.h) you need to call your dll hope this helps si

Thanks all,i solved the problem using CRecordset.

Why not just use ODBC to create the table and insert the data?  onwards and upwards...

Connect and access it just as you would SQL Server. The only real difference is the number of concurrent connections it supports, resource usage limits and the fact that it does not come with the SQL tools (EM, Query analyzer, etc.).  onwards and upwards...

Hi, BUlk insertion is not possible in MS Access, but u can do it in Sql Server, just chk out the documentation of BULK INSERT in MSDN, and use _ConnectionPtr to connect to datasource using ADO. best wishes..mil10

HI, THANKS FOR REPLY.BUT I COULDN'T UNDERSTAND YOUR SUGGESTION PROPERLY.WHAT DO U MEAN BY EXTERNAL LINK?HOW IT IS CREATED ,CAN U TELL ME THROUGH A SMALL SAMPLE CODE? THANKS AGAIN.

Simply wait. Be sure that if someone has a solution, it will post it here. But do not be too insistant, this usually is the best way to get no answer. ;) ~RaGE();

Thanks John for help.

I have found that the MFC database classes SUCK. You may be better off doing one of the following: 1) If the name of your text file doesn't change, create a Linked Table in access to your text file. Then, you can use access insert/select statements to copy the data. -or- 2) build your own insert statement from the retrieved data and execute it against access, rather than using all of the overhead crap of CRecordSet. onwards and upwards...

Did you map/define the 6 fields in your ODBC DSN setup? You need to do this to access the fields in a text file correctly (including field delimiter, Field name, logical data type, etc...).

What you need to do is to properly configure the DSN. This includes selecting the directory and defining the layout of each file that you will want to query. Be aware that the standard MS ODBC Text File driver operates in a read-only manner and does not use any form of indexing (Table Scan every time!).