|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| PriceLevelPerItem Insert/Import problems |
| Author |
Message |
|
|
| Posted : 2008-05-03 03:46:51 |
| I am using QODBC v8 and running an Access DB with the linked tables back to the quickbooks db. I need to import about 13000 records into the PriceLevelPerItem table. I created my excel file and started an import through access. I was able to successfully import 64 items, then it bombed out and I haven't been able to import any since. It errors out saying it cannot import the file. (yes I deleted the records from the excel file that already imported) What am I missing to make this work?? I have tried using the sp_batchstart and update to import batches of files with no luck. Any thoughts would be appreciated. Thanx!! |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-05-03 10:09:10 |
Sorry, "it cannot import the file" isn't a QODBC error. You need to check the end of QODBC Messages Log in the QODBC Setup Screen Messages Tab for the true cause for the error.
See: PriceLevelPerItem Updates & Inserts for more. |
|
|
|
|