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
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Microsoft Access Connection
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
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.)
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.)
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Semrush [Bot] and 23 guests