Old hand to programming in Clipper, New to VBA 1

[DevinTX]

I seem to be lost. I am an old DOS/Clipper programming (been away for several years) need to understand the basics of how to open a database. I have been playing with MSAccess 97 and 2000 for a couple of days and still not sure how to to handle the basics.

ie what is jet, DAO and which is better. (or is that the wrong question)

I would appreciate any help you can offer. I'm not dumb just lost

DevinTX

 

[JerryDennison]

What do you mean by "open a database"?

There are some similarities between DOS/Clipper and Access. While DOS/Clipper used database files Access uses Tables. So an Access database would be comprised of many tables where your DOS app would use many databases.

What is the nature of your problem?

 

[DevinTX]

I have tried to open a "TABLE" as a database and got invalid type. I tried to open as a recordset and ran into the same prob. can you show me a small bit of code to use to open a table and add/delete or edit the data.

My main goal is to import a growing text file search for non duplicate records and add new records into an Access Table

Thanks for the reply
DevinTX

 

[JerryDennison]

Actually, you can do all this without code(one of the nice features of Access is that almost everything can be accomplished without writing a single line of code). Import the text file into a new or existing table. You can then use this table with an append query to add the records you wish to the table of your choice.

 

[scking]

And--If you build the database you want to import it into prior to the import and properly define the PrimaryKey then any duplicate records will not be added. There are multiple approaches to this same problem but, as Jerry said, you don't need to go the code route.

Steve King