bro
kindly send code in pvt msg
regards
suneel kar

hello manohar
where r u bro.u told me that u gonna send code in 15 mins .but i have not received any code yet.i have cheched both pvt msg ans gmail also.plz tellme where u have send code.
regards
suneel

Suneel,
I have emailed the complete program to you. Do not ask me like this any more. Because, I am a very busy person. For your requirement I have to stream line the code and after testing I am sending it to you.
Do not give the sourse code to anybody. Keep it to yourself

You have to change the path in the connection string for the dbase file. Your data file will be created in c:\drive. The data file can be imported to Excell very easily by giving the delimiter , (coma)

You have to do some preliminary works.

Follow as bellow, carefully.

Before copying the text code into you project, Open a new exe project, pull down the menu project, then select components. in components control pannel check the following item.

ctv OLE Control Module
Microsoft ADO Data Control 6.0 (sp6)(OLEDB)
Microsoft Datagrid control 6.0) ..

Press OK

Now Go to references in the same Project window
and see the following are checked

The top 4 are defaulted.
That is up to OLE automation
then,
check microsoft jet and replication objects
microsoft ado ext.2.8
microsoft activex data objects
microsoft DAO 3.6 (incase the ADO doesn't work)

Click ok

create a form with one commandbutton
click the code window from the right pan
and select form local

paste my code

change the path of your dbf file in the connection string.

Do not alter the connection string.

run it

You form window will be shown with the commandbutton captioned as successfully Extracted.
Click it
the form unloads.

check in c:\ drive for the data.txt file. every time you run the program it will be recreated afresh. No killing and creating in your program code, OK

Study the code carefully.
I think when you get the connection 75% of your job is done.


Happy programming

AV Manoharan

What makes any difference if you are using VB? What's the advantage and disadvantage? What can do the DAO and the ADO cannot or vice-versa? The question to the programmers is that How I will connect to the database? Which is more convenient to me? Ok granted that the DAO is outdated, but the question is, what makes any difference its just a connection to the database where you will save your data, right?

Jireh,
Kindly change your BLOB. It has a threatening look!

Now, your Doubt.

DAO or ADO. What is the difference. And all that.
See, I have elsewhere in this thread explained the diiference briefly.

Hear me more.

If you are a DBA or DBD (Database Administrator or Database developer), you require frequent access to so many varities of data souces such as server-based, desktop, spreadshhet, textfiles etc. type of databases. You might have witnessed in this forum people asking the same question of connecton to ACCESS, dBASE etc. data bases.

If you think of developing custom built interfaces for each type of databases, then you can imagine the difficulty of a programer. Here only microsoft's contribution of DAO and ADO becomes so valuable for a developer in Microsoft environment. It relieves much burden from a programmer by giving himm an abstract highlevel interface.
DAO and ADO basically does the same thing. But why ADO instead of DAO is that DAO is the earlier technology and ADO is new one. The technology is ever changing.

Microsoft is known for its dubious reputation in the software industry as a 'developer-locking Giant', means making developers and end users stick to Microsoft environment. By the introduction of ADO, actually, Microsoft restricted developers from going to platform independed environment (eg. Java). Microsoft included ADO drivers for any data sourse you can imagine. Text File database, Spreadsheet databases, oracle databases, IBM DB2, SQL databases... the list is endless.

Still, why, ADO instead of DAO?
Very simple. Microsoft announced, stopping of further updation on DAO. Only ADO will be updated. Means, if a new technology database comes you will have only ADO for it. Not DAO.

Is it clear to you now?

Happy Programming
AV Manoharan