Hello,
I am trying to do from what I understand is a simple thing. I have a text file, which is comma delimited. I want to create a C++ program which will take the information and put it into a Microsoft Access format. So more or less the program will take the data in a text file and transfer into a database.

Now I know that I could just open Access, then use the open button and import the text file that way, but that is not my goal. I want to do all this using a seperate C++ function.

Is this possible? Could you give me a suggestion on how to do it. Thanks for your time.
~David

I guess I would not mind doing this in Visual either, but I would prefer just regular C++. Thanks

Hi,

I'm not sure of how to import a text file into a access database, you have to check MSDN for info on MSAccess.

Are you familiar with MFC, I'm not suggesting you to learn MFC since you prefer to use the normal c++, but take a quick look at what it has to offer. I haven't done any database programming before and not interested to do it. I can give a hint MFC classess that could help you achive what you want to do.

"Microsoft ActiveX Data Objects (ADO) allow you to manipulate and store your data in a database server through an OLEDB provider, and as it provides dual interface you are able to use it from both scripting languages such as VBScript and JavaScript as well as C++. It has so many advantages such as high speed, low memory overhead and the most important one, ease of use."

for more info, check out this Article On MSADO

This is an article provides classess which would make easier to work with ADOCAdoDatabase

Now, with Ado you can access the database and create a new table and insert the data from the file to the database.

This is just a suggestion or to give you a hint on what to do. there are more classess which works with ADO and you should find the best that suits your needs or make your own classess.

Hope that Helps.

Hey,
your articlew were very helpful. Thanks

I do have a small question for you. Your first link showed me how to change data in a database with VC++ GUI. I understand this much better, but the site did not talk about making an Access DB or how to create Tables in an Access DB, or in the tables how to create columns. These are all things that I will be doing through VC++. You have already helped me a great deal and I thank you. If you have any other links that might talk about one of the other areas which I mentioned could you please share. Thanks again.