SageForum for UK versions of Sage 50- Help and support.

Hi , I need to extract data from sage to import into a CSV file , I can do most of it , but just need some pointers :-

I am going to need Delivery address for each order , I assume the Invoice Table ?
also the Customers e-mail address , where is this held , i can't seem to find it.

I assume the customer will be linked to invoice by customer account ref ?

I have got a ODBC connection open with Access so can see all the tables , is there anywhere I can mark an invoice as "shipping label printed" by using an update query ?

Thanks for your help

Sage Newbie !

You can not update sage via odbc it is one way.

You can update the data in sage by using the SDK at £1500 pa or you can use a 3rd party integration tool like the one we sell for £225

The email address is in the Sales Ledger Table.

ODBC is a bit slow, there are other ways to do things if you need to be quicker.