473,241 Members | 1,495 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,241 software developers and data experts.

Connecting to SAGE

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 connecting? Which is
best?

Thanks,

Franc.
Jun 27 '08 #1
2 3043
On May 15, 9:55*am, franc sutherland <franc.sutherl...@googlemail.com>
wrote:
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 connecting? *Which is
best?
Which Sage? I've had sucess connecting to the Sage Fundraising
products via ODBC. I think they lock down access to read only, but it
was sufficient for the queries I needed to run. Interesting data
model.

I never had the need to connect directly to Peachtree - it's import
export automation is quite sophisticated.

Tim Mills-Groninger
Jun 27 '08 #2
On May 15, 7:03 pm, timmg <tmillsgronin...@gmail.comwrote:
On May 15, 9:55 am, franc sutherland <franc.sutherl...@googlemail.com>
wrote:
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 connecting? Which is
best?

Which Sage? I've had sucess connecting to the Sage Fundraising
products via ODBC. I think they lock down access to read only, but it
was sufficient for the queries I needed to run. Interesting data
model.

I never had the need to connect directly to Peachtree - it's import
export automation is quite sophisticated.

Tim Mills-Groninger
Hi Tim,

Thanks for your reply. It's a basic SAGE account package like Line 50
or Quick Accounts (or something like that).

Where did you get the ODBC drivers from?

Thanks,

Franc.
Jun 27 '08 #3

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

Similar topics

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: cheungs7 | last post by:
Hi all, Wondering whether you can anyone help me. We have Sage Payroll (and accounting/payroll software), which has a MS Access database where the data is stored. Now I want to access the...
2
by: kj | last post by:
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
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 ...
8
by: cdo4 | last post by:
I currently have Sage MAS200 SQL (with eBusiness and full support) and looking to launch a consumer ecommerce site. I also have an old website (we took it offline to focus on distribution) written...
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,...
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...
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...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.