5/23/2012 11:34:26 AM
Access Import for QuickBooks Data
By Richard Rost
I have a customer who NEEDS to be able to import QuickBooks data into his Access database on a regular basis. Once a month he wants to download his banking info from his bank's web site which is in QuickBooks format (a pretty standard format) but instead of using QuickBooks, he wants to pull that data into his Access database to track his expenses.
This is a semi-complicated thing to do because although QuickBooks data is a standard TEXT file, you have to read the fields a specific way... then of course you have to check for duplicate entries, and so on.
The reason why I'm posting this here is because I want to know if ANYONE ELSE is interested in seeing how to do this? If a handful of you are interested then I'll make this into a mini seminar. If not, I'll just build it for him and be done with it.
So... if you want to see a mini seminar for this, click here to VOTE FOR IT ON THE WAITING LIST. I put an estimated price of $29.99 for it... but it could be less depending on how long the seminar is. I can't see it being more than a 2 hour seminar... unless I decide to go crazy and add a bunch of cool extraneous stuff like I always do (but remember, I'll NEVER automatically charge you MORE than what is listed on the Waiting List without checking with you FIRST).
Also, feel free to sound off here and post your comments about this seminar. What additional topics would you like to see covered? Should this just be a quickie or would you like to see lots of extra stuff?