How to download sales into a relational database... ?

[A Stewart]

[Sorry my software forces me to start a new thread. Thanks
Bill Gates... ]


All we are trying to do is suck down sales into a
relational database.

Entity structure:
Obviously there is one entity for a "Sale" and
each "Sale" can have one or more products
or "Sales Lines" within it.

We need to be able to extract the data into our
existing stock-control/accounts package
(called "Options").

But even if we could get it into MS Access, that would be
a start!


Ship

P.S. Stone Edge's "Order Manager for ShopSite" looks interesting
but we don't currently have the budget for it !

[Norman]

You might try WriteItOnce at http://www.writeitonce.com This company
specializes in data conversion software. If their current offering does
not work with your files , they have you send a sample file and will
adjust their program to work with your data. The program we purchased
works beautifully now but be forewarned, this is NOT standard off the
shelf software. It did require 3 weeks of sending sample files and
detailed error messages to get the program up and running. The company
would adjust the program each time and email an upgraded version.

Norman
1 Ocean Boulevard
Beautiful, Quality Swimwear
http://www.web8.com/ocean


A Stewart wrote:

[Sorry my software forces me to start a new thread. Thanks
Bill Gates... ]

All we are trying to do is suck down sales into a
relational database.

Entity structure:
Obviously there is one entity for a "Sale" and
each "Sale" can have one or more products
or "Sales Lines" within it.

We need to be able to extract the data into our
existing stock-control/accounts package
(called "Options").

But even if we could get it into MS Access, that would be
a start!

Ship

P.S. Stone Edge's "Order Manager for ShopSite" looks interesting
but we don't currently have the budget for it !

[A Stewart]

Come on ShopSite!
- give us some help here...

Surely this is something *everyone* will need to do -
(everyone who want to track what they've actually
been selling that is!)

Alec





"Norman" <shop1ob@aol.com> wrote in message news:3CE309EB.3FF9E7B5@aol.com...

You might try WriteItOnce at http://www.writeitonce.com This company
specializes in data conversion software. If their current offering does
not work with your files , they have you send a sample file and will
adjust their program to work with your data. The program we purchased
works beautifully now but be forewarned, this is NOT standard off the
shelf software. It did require 3 weeks of sending sample files and
detailed error messages to get the program up and running. The company
would adjust the program each time and email an upgraded version.

Norman
1 Ocean Boulevard
Beautiful, Quality Swimwear
http://www.web8.com/ocean


A Stewart wrote:

[Sorry my software forces me to start a new thread. Thanks
Bill Gates... ]

All we are trying to do is suck down sales into a
relational database.

Entity structure:
Obviously there is one entity for a "Sale" and
each "Sale" can have one or more products
or "Sales Lines" within it.

We need to be able to extract the data into our
existing stock-control/accounts package
(called "Options").

But even if we could get it into MS Access, that would be
a start!

Ship

P.S. Stone Edge's "Order Manager for ShopSite" looks interesting
but we don't currently have the budget for it !