08-18-2006, 08:19 AM
Hi- I used QM to pull some info from a work website and format it, and now I am trying to insert same data into an MsAccess mdb database. But the available help and conversations on the forum aren't enough to get me up and running, given my knowledge of SQL and Database accessing.
Can you provide a clear, real-code example of accesing an Access database that:
1. Opens the database
2. Checks 1 field to ensure record is not created already, and if it has been, updates the record
3. If no record exists per #1, adds a record to the database
4. Closes the database
I have tried a couple dozen variations given what I can find via available QM resources, but the examples provided currently give me syntax errors every time.
I appreciate any help that can be provided.
PS the current examples don't provide field names, so I assume the field info is passed sequentially per the DB schema, is that correct? If so, if you only need to initially populate the first 4 fields, for example, can you leave off the trailing, empty fields, or do you have to represent them (i.e. with '','', etc)? That is one point I am unclear on.
Thanks
Again
Can you provide a clear, real-code example of accesing an Access database that:
1. Opens the database
2. Checks 1 field to ensure record is not created already, and if it has been, updates the record
3. If no record exists per #1, adds a record to the database
4. Closes the database
I have tried a couple dozen variations given what I can find via available QM resources, but the examples provided currently give me syntax errors every time.
I appreciate any help that can be provided.
PS the current examples don't provide field names, so I assume the field info is passed sequentially per the DB schema, is that correct? If so, if you only need to initially populate the first 4 fields, for example, can you leave off the trailing, empty fields, or do you have to represent them (i.e. with '','', etc)? That is one point I am unclear on.
Thanks
Again