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

Hi,

Is is possible using the ODBC drivers to connect Sage line 50 v14 to Access ?, I have read somewhere that the ODBC drivers are read only

I am looking at importing data like stock records etc. I know there is the import function in sage, but ut has some fields missing like purchase nominal code and means you have to update each record individually

Many Thanks

Bruce

ODBC drivers work fine with access as you have already found out they are read only.

If you want to write data back into sage, then you need to use a third party product such as the one we sell this work by dumping the data you want to put into sage into a csv file (you can do this from a query). You can import the csv file using the GUI or to be really smart you can use a little VBA and a shell command to run the import from your application (and check it all worked okay)

Writing the importing customisers can be a little daunting, but is pretty easy when you know what you are doing, unless you plan on becoming an expert, we would generally undertake to do it for you and provide you support for the installation, VBA etc at a modest extra cost.

The import program is £225 a modest cost would be £50 per hour (it takes less than an hour to write most simple customisers.)