473,382 Members | 1,355 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Connecting to sage line 50

kj
Hi people,

newcommer here, i know a little ms programming but am new to sage,
Is it possible to connect to sage line 50 with ms access?

TIA
Keith
Nov 13 '05 #1
2 6904
"kj" <kj@hfjdsdfsa.com> wrote in message
news:d4**********@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com...
Hi people,

newcommer here, i know a little ms programming but am new to sage,
Is it possible to connect to sage line 50 with ms access?

TIA
Keith

You can get read-only drivers for free, but if you need to update you get a
Developer's kit from Sage. Have you taken a look at their website?
Nov 13 '05 #2
To read Sage Line 50 data just set up an ODBC connection using the
driver that is installed with the Line 50 program and then link to the
tables in Access (worth setting up a separate user in Sage and then
saving the password when linking the tables, also note Sage is a bit
case sensitive in some areas such as account refs, etc)

To write to Line 50 Justin is correct you need to be a Sage Line 50
Developer - this costs!! - if this is a minor part of your
requirements it may be an option to write your access database and
then have a standalone 'Post to Sage' database that shares the same
backend.mdb but is written by a Sage developer (I have done something
similar for a customer who wanted full access to his database so I
separated off the posting to Line 50 module)

Drop me an email if you need more specific details or contact the Sage
developer team for a developer in your area
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: eSc | last post by:
I am trying to connect to Sage Line 50 data files through odbc driver (SageLine50v8) from php5 (running on windows xp pro) by odbc_connect(). Unfortunately I can not find right connection string...
0
by: Phil | last post by:
My mission is to get some data out of a sage application, via a very complicated query, into a csv file. My approach, so far, has been 1) link access tables to the sage application 2) build...
1
by: Duncan | last post by:
Dear friends, I have a client which would like us to post data into SAGE Line 50. Are there any API or Controls or methods out there that you know off which would help us achieving the task ...
2
by: spiritedSmile | last post by:
Hi, I would like to write ASP code to create a custom report for a simply accounting database. The databse is saved with a .sdb extension. I am able to access the data via access or excel so I...
3
by: Rshah | last post by:
Anybody know syntax of sage line 50 query? how can I write sage line50 database conidtion sql query? when i write this syntax, get error msg of column not found. 'SELECT c.stock_cat_name,...
1
by: Gurdeep Toor via AccessMonster.com | last post by:
Hi Folks, I am building an application in VB.NET... It connects to 2 databases MS SQL SERVER 2005 and MS ACCESS 2003 .. It works all fine with SQL but It only reads the record from the ACCESS...
0
by: marc.holt | last post by:
Please help! I am attempting to extract data from a Sage Line 50 database ( .dta extention) via an ODBC connection. Included in the application install of Sage Line 50, is an ODBC driver. I...
2
by: franc sutherland | last post by:
Hi, I am trying to build a database in Access 2003 which can connect to information in a SAGE system. Should I use ODBC, and if so, which driver is required? Is there another way of...
6
by: jadamwilson2 | last post by:
Hello, I have recently become interested in using python for scientific computing, and came across both sage and enthought. I am curious if anyone can tell me what the differences are between the...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.