Post reply

Create table in MS SQL Server ffrom Quickbook

  • November 14, 2013 at 7:48 am

    #395823

    Hi Experts

    Can anyone please guide me how to create destination dynamically as its from Quickbook Source table.In Quickbook i am having 150 tables,how to create table in SQL Server and import the data.

    please guide me experts.

    Thanks in advance.

    --------------------------------------------------------

    I am Learner -- SQL

  • November 17, 2013 at 5:44 am

    #1666933

    Export the data from Quickbook (e.g. as formatted txt files) and use SSIS to read the folder and import the data.

    If you don't want to use SSIS , you could read the content of the folder into a table using

    EXEC Master.dbo.xp_DirTree 'yourpathhere',1,1

    and fetch over each row to dynamically create the OPENROWSET statement.

    As to my knowledge there's no direct connection available to connect to Quickbook.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • December 4, 2013 at 10:48 am

    #1670795

    at one point, built a .NET project that used the quickbooks connector from http://www.rssbus.com/;

    with that, and some minor configuration in quickbooks to allow remote access, i was able to see all the "tables" that exist in the quickbooks database live, and then could query them, use LINQ to join them together, export them out to a SQL server database or to disk or anything i wanted to;

    I used the 30 day trial as a proof of concept, and then the company i was consulting for bought a license to go with the application.

    the one thing at the time, that i felt that was lacking, was the ability to read the relationship between an invoice detail line items that exist on an invoice, and where/how they were tied to items in the ledger; that was with the RSS 1.0 version, and it's several versions worth of improvements since then.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply