This is Urgent! :)
Ok im using Ms Access (2002) as the backend to a program i have developted in vb6, this is for a college project and im currently at the business that this poposed program is for. They use Sage Instant acounting 6 as ther current system and have thousands of records for invoices / customer etc (there invoice count is up to about 58,000
So my question is how do i transfer the records for ther customers, products and invoices to my access db.
I was thinking of copying / converting the sage record to a text or excel file then importing them to access.
If anyone has a tutorial or ideas how to do this please say :)
9 4953 Minion 108
Recognized Expert New Member
If you end converting to a csv (comma seperated value) file then I would check out the Import csv (Comma Separated Value) File tutorial on this board. This should help you read into your db from a file.
Though I was wondering what the current format for the records is? I'm personally not familar with the Sage software, so I don't knwo what file format the records may be in.
Hope this helps.
- Minion -
Sage, isn't that the same company that bought Act! contact manager from Symantec awhile ago? Have you tried looking on their website for any related information?
Act! allows you to export to a text delimited file, does the Instant Accounting software provide similar functionality?
Regards,
Scott
A quick Google of Sage Instant Accounting 6 gave me this site as well.
Regards,
Scott
If I understood your original post correctly, you're using Access as a backend only with a VB 6 frontend. I would think you'd be better off concentrating on how to import this data thru VB6 and posting this question on that forum. You Access backend, after all, only contains tables, does it not?
Linq ;0)>
Act! allows you to export to a text delimited file, does the Instant Accounting software provide similar functionality?
Regards,
Scott
I cant find any function to export data from sage instant accounts 6 to either a text file or a excel file.
ive looked so far and i cant find anything , but i still got lots of post to go on either of ther forums :S
most of them are for ACT! which isnt the same as sage instant accounting
Glad you found something that works! And thanks for posting back with a solution.
Regards,
Scott
Check out SageDataObjects .com, they have an API that you can use for the import.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Mark Line |
last post by:
Hello!
I'm a python n00b!
I've been writing in c++ for a few years so programming's not new to me,
just python that I don't know the syntax!
|
by: Bayou BoB |
last post by:
Hello;
Simple question for most I'm sure. I'm curious how many records MS
Access will store in a single database? What happens when you reach
that number of records? Do you just lose the ability to enter new
data? Or will it crash on you? What does one typically do when you are
approaching the end of Access' ability to store data? Additionally,
how many records will SQL store? Thanks!
Kevin
|
by: Darren |
last post by:
I have been attempting to create a reservation planning form in excel
that imports Data from an Access database and inserts that information
automaticly into the correct spreed sheet and the correct cells within
that worksheet. The Excel Book is made up of 12 worksheets named
Jan-Dec. Each worksheet has columns labeled as each day of that month.
Column 'A' is reserved for 19 rows named "room1 - room19". The data I
am importing from the...
|
by: bsmith1111 |
last post by:
Before I start- Office Xp and only basic knowledge of Access. Here's
what I'm trying to do:
I've got an Excel file with four columns:
Name Description Place Misc
I import this file to a Temporary table in my Access database. (I have
queries to delete everything in this temporary table and puts the new
info here- everything works fine to this point)
I also have a Permanent table which has these 5 fields:
Name Description Place Misc Price
|
by: nizar.jouini |
last post by:
Hello.
I have long text file whitch is formatted like this:
nextrow4
asdf
asdf
| |
by: candid14 |
last post by:
1. Is there a max number of records that you can import into an Access 2000 database?
2. Is there sample code to importing data from one text file then automatically importing data to another text file?
|
by: hharriel |
last post by:
Hi,
I am hoping someone can help me with an issue I am having with excel
and ms access. I have collected data (which are in individual excel
files) from 49 different school districts. All districts have used the
same excel template and populated the same 32 data fields (columns). I
created one large excel file from all 49 files which gives me a master
table of 60,000 or so records. I have tried to import this master
table into access...
|
by: Manal |
last post by:
What is the max number of records in Access?
|
by: vikas1111 |
last post by:
Hi All..
I want to access records from access database and edit them and save the changes using visual basic.. How can i do that ???
Can anyone please help me???
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |