Running an Append Query in Access |
Author |
Message |
Mel |
|
Group | : Members |
Posts | : 4 |
Joined | : 2009-01-19 |
|
Profile |
|
Posted : 2009-01-19 08:34:01 |
I am having trouble running my append query in Access. I get an error stating that Access does not recognize the database format OLBDEF.dat.dsn. How can I get these tables to link up so I can append my price levels into Quickbooks??
Thanks much!!! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-19 15:36:07 |
|
|
|
Mel |
|
Group | : Members |
Posts | : 4 |
Joined | : 2009-01-19 |
|
Profile |
|
Posted : 2009-01-20 03:45:09 |
Tom,
I have reviewed the information you gave me and now I am a little confused. I am not very familiar with programming language and I am not sure what I need to do with the information you just gave me.
I have an Access database that contains all of my 7563 items and their 5 price levels, I exported the names directly out of Quickbooks so they are already in the program. I just need to know how I can get that information out of Access into QODBC. If you could give me an example of how to do this I would be very appreciative.
Thanks!!! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-20 09:34:43 |
As stated already, inserting records into the PriceLevelPerItem requires special formatting that isn't going to work with a simple APPEND. It will require a sub-procedure and both the SQL for PriceLevel inserts or updates and an example sub-procedure were provided in the previous response. |
|
|
|
Mel |
|
Group | : Members |
Posts | : 4 |
Joined | : 2009-01-19 |
|
Profile |
|
Posted : 2009-01-24 07:14:17 |
Tom,
If I am following these posts correctly then I will need to go into QODBC and type in all of the items, price levels and prices. Am I following this correctly? Or is there some way I can get the information from my Access table into the QODBC table? I hae all of the items in the access table entered into Quickbooks so I am not adding any of them, I am just trying to add all 5 price levels to the program. I must appologize if I am just not understanding what you are telling me, I was just under the impression from another post on this website that I could get the information from one to the other rather easily. I would appreciate any detailed instructions you could give me for accomplishing this task.
Thank you very much for your patience and assistance.
Mel |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-25 16:40:51 |
|
|
|
Mel |
|
Group | : Members |
Posts | : 4 |
Joined | : 2009-01-19 |
|
Profile |
|
Posted : 2009-01-29 02:00:22 |
Tom,
I am still having trouble setting this up. I set up the pass-through query in Access however I am having trouble with the SQL that needs to be put in it. You referenced a sample code for creating invoices and said it could be modified to build price level updates however I don't know much about SQL and I am not sure how to modify it. Do you have a sample of the code that would be needed to do the price levels? There were other samples in that same forum for it but none of them were working for that individual and they aren't working for me either. If this is something you can't help me with could you tell me if there is some type of help desk I can contact or someone there that can assist me with this? In particular, are there programmers there that can assist with this? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-29 11:04:52 |
The actual SQL is clearly shown in: PriceLevelPerItem Updates & Inserts. This is a QODBC Support forum only and does not cover consulting services on how to program using MS Access. |
|
|
|