|
|
Does anyone know if you can export date to Quickbooks from Access 2007 and
reverse?
Thanks,Barb
|
|
|
|
Thank you Daniel, I will try that.
Barbara
"Daniel Pineault" wrote:
[Quoted Text]
|
|
"Scarlet59" <Scarlet59[ at ]discussions.microsoft.com> wrote in message
news:E39784C1-5302-4E26-8B93-0750A7B1AEE5[ at ]microsoft.com...
[Quoted Text] > Does anyone know if you can export date to Quickbooks from Access 2007 and
> reverse?
> Thanks,Barb
QuickBooks does link with some databases using an ODBC driver:
http://www.qodbc.com/qodbc.htm
The earlier versions that I used were very slow, and expensive $200. for
each version. They also don't allow interaction with some tables.
QuickBooks does have an SDK, but you cannot program Access compatibility
with it as it uses C, C++, or C#, not VB or VBA. So you would need to be
able to program C or C++ COM objects to make it work with Access.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
|
|
Arvin,
That sounds great. I'm not sure about having to write codes to get a program
to work. This looks much easier.
Thanks
"Arvin Meyer [MVP]" wrote:
[Quoted Text] > "Scarlet59" <Scarlet59[ at ]discussions.microsoft.com> wrote in message > news:E39784C1-5302-4E26-8B93-0750A7B1AEE5[ at ]microsoft.com... > > Does anyone know if you can export date to Quickbooks from Access 2007 and > > reverse? > > Thanks,Barb > > QuickBooks does link with some databases using an ODBC driver: > > http://www.qodbc.com/qodbc.htm> > The earlier versions that I used were very slow, and expensive $200. for > each version. They also don't allow interaction with some tables. > > QuickBooks does have an SDK, but you cannot program Access compatibility > with it as it uses C, C++, or C#, not VB or VBA. So you would need to be > able to program C or C++ COM objects to make it work with Access. > -- > Arvin Meyer, MCP, MVP > http://www.datastrat.com> http://www.mvps.org/access> http://www.accessmvp.com > > > |
|
Arvin,
It feels wierd correcting you of all people (as I am usually asking you for
help), but the SDK does indeed permit vba coding with Quickbooks. I have
sucessfully used it in Excel and Access now. Perhaps the older versions did
not, but the current SDK does permit vba integration/programming. Add the
proper references to your project and you're off the the races (as they say).
The process can be slow however, but does work.
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
"Arvin Meyer [MVP]" wrote:
[Quoted Text] > "Scarlet59" <Scarlet59[ at ]discussions.microsoft.com> wrote in message > news:E39784C1-5302-4E26-8B93-0750A7B1AEE5[ at ]microsoft.com... > > Does anyone know if you can export date to Quickbooks from Access 2007 and > > reverse? > > Thanks,Barb > > QuickBooks does link with some databases using an ODBC driver: > > http://www.qodbc.com/qodbc.htm> > The earlier versions that I used were very slow, and expensive $200. for > each version. They also don't allow interaction with some tables. > > QuickBooks does have an SDK, but you cannot program Access compatibility > with it as it uses C, C++, or C#, not VB or VBA. So you would need to be > able to program C or C++ COM objects to make it work with Access. > -- > Arvin Meyer, MCP, MVP > http://www.datastrat.com> http://www.mvps.org/access> http://www.accessmvp.com > > > |
|
"Daniel Pineault" <DanielPineault[ at ]discussions.microsoft.com> wrote in
message news:4EAA8BDF-ED77-47A2-B748-494A4688EC56[ at ]microsoft.com...
[Quoted Text] > Arvin,
>
> It feels wierd correcting you of all people (as I am usually asking you
> for
> help), but the SDK does indeed permit vba coding with Quickbooks. I have
> sucessfully used it in Excel and Access now. Perhaps the older versions
> did
> not, but the current SDK does permit vba integration/programming. Add the
> proper references to your project and you're off the the races (as they
> say).
>
> The process can be slow however, but does work.
Hey, my wife corrects me constantly <g>
Thanks for the correction. I was going by what I saw on their website. The
older versions only allowed C or C++ (not even C#) and didn't really even
have an SDK when I tried working with it last time.
When you say slow, do you mean painfully slow? It was when I used the ODBC
connector. I seem to remember a query taking about 35 seconds to return 18
rows from a table with a little over 700 rows. In Access, that would be
measured in microseconds.
Thanks,
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
|
|
Sadly, the speed issue remains. It is 'painfully slow'! but it does work.
Sending info to QB is done at an acceptable speed. Ie transfering db data to
QB to create a new client or invoice...., but retrieving QB info is
rediculously slow.
I need to query QB to pull item listings and tax codes and you might as well
go grab a coffee and come back before it will have completed the query.
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
"Arvin Meyer [MVP]" wrote:
[Quoted Text] > > "Daniel Pineault" <DanielPineault[ at ]discussions.microsoft.com> wrote in > message news:4EAA8BDF-ED77-47A2-B748-494A4688EC56[ at ]microsoft.com... > > Arvin, > > > > It feels wierd correcting you of all people (as I am usually asking you > > for > > help), but the SDK does indeed permit vba coding with Quickbooks. I have > > sucessfully used it in Excel and Access now. Perhaps the older versions > > did > > not, but the current SDK does permit vba integration/programming. Add the > > proper references to your project and you're off the the races (as they > > say). > > > > The process can be slow however, but does work. > > Hey, my wife corrects me constantly <g> > > Thanks for the correction. I was going by what I saw on their website. The > older versions only allowed C or C++ (not even C#) and didn't really even > have an SDK when I tried working with it last time. > > When you say slow, do you mean painfully slow? It was when I used the ODBC > connector. I seem to remember a query taking about 35 seconds to return 18 > rows from a table with a little over 700 rows. In Access, that would be > measured in microseconds. > > Thanks, > -- > Arvin Meyer, MCP, MVP > http://www.datastrat.com> http://www.mvps.org/access> http://www.accessmvp.com > > > |
|
"Scarlet59" <Scarlet59[ at ]discussions.microsoft.com> wrote in message
news:E39784C1-5302-4E26-8B93-0750A7B1AEE5[ at ]microsoft.com...
[Quoted Text] > Does anyone know if you can export date to Quickbooks from Access 2007 and
> reverse?
> Thanks,Barb
|
|
|