|
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
|
|
| Importing data to quickbooks from Excel |
| Author |
Message |
|
|
| Posted : 2007-03-25 15:28:23 |
| Can anyone share information on how to bring data into QuickBooks from Excel and more specifically how to bring data into the QuickBooks BillExpenseLine Table from Excel? Thanks. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-03-25 16:37:57 |
Reading the data out of QuickBooks is easy. See: How do I use prompted date ranges in MS Excel?, just use the BillExpenseLine table instead of the InvoiceLine table shown.
However importing the data requires programming either by VBA or via Access and is beyond the current scope of this FREE forum. I hope to build some examples using MS Office 2007 in the near future. |
|
|
|
|