Re: Importing bookkeeping data

Dale E. Reed Jr. ( (no email) )
Tue, 16 Jun 1998 11:09:21 -0700

Olivier Astier wrote:
> I want to import data from my current Bookkeepping software : QuickBook
> I have recovered the quickbook data in text and excel format.
> The problem is that I don't know how to import them in the Emerald SQL
> database. I think I could create a SQL query by inserting the right SQL
> commands between the database fields in Excel, but I don't know wich
> commands and maybe there's an easier way to do this.
> If you already faced this problem could you help me with that? Please assume
> that my SQL skills are limited ; but I learn quickly.

This is not a trvial task to accomplish and without in depth SQL
experience and knowledge, I can only recommend you talk to us
about doing it for you. It typically takes about 5-6 hours of
consulting to convert a CSV or excel type user information into
Emerald. The cost is minimal compared to the time and effort
you would put into it yourself trying to accomplish this.

Please don't take this the wrong way, as I am not saying you
couldn't do it. Its just that we have had a lot of customers
who were in-experienced in SQL Server try, and they all eventually
just asked us to do it. I'm trying to save you from going down
that same road. :)

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |