Devam Ediyor

Exporting data from MS DOS to Access

There are MS-DOS files, an Acess file and an Excel file attached. All will be described below.

I have very limited programming knowledge but was given a group of files created in 1997 that together make up a fully functioning very basic MS-DOS invoicing program. With this program you can view invoices and create new ones. . The only portion of this application that requires focus is the one accessed by selecting "View Invoice".

What I need to do is export the data viewable in this application to an existing blank formatted Access database. You will notice that the attached files contain 4 of such MS-DOS applications all bearing the same structure. I require the data extracted from all four of them.

There are two database tables that the data needs to be placed into. One is DocumentHeaders, which contains all of my customer-specific information that is contained with each invoice listed within this table. The other Access table is DocumentItems, which contains the actual products purchased for each invoice. Obviously, more than one product can be purchased on each invoice so there is a one to many relationship of one invoice number (the DocumentHeaders->ID field) per many items purchased for each invoice (the unique primary key DocumentItems->DocID field gets repeated per corresponding DocumentHeaders->ID field).

The attached Excel document lists which MS-DOS fields correspond to which Access fields. Any MS-DOS fields not listed are to be ignored and do not require migration to Access. If the MS-DOS invoice record reads "Same as Billing" by the billing company information, I would require the data from the SoldTo Access fields (listed on the Excel document) to be identical to those from the ShipTo fields of the Excel document.

So the data needs to migrated to these 2 Access database tables. However, I am left with a concern. Once I am presented by you, the programmer, with the database containing the extracted data, I will be merging it with an existing Access database of identical structure which already contains a lot of the same type of invoice data. My concern is that the DocumentHeaders->ID field is an autonumber primary key unique field. How can I arrange to have this field of the newly provided database continue where the existing database's identical field leaves off? Must I provide you with the existing database in order for this to work?

Beceriler: C Programlama, C# Programlama, C++ Programlama, Microsoft Access, Yazılım Mimarisi

Daha fazlasını görün: exporting data dos access, exporting data dos, dos access, export data dos invoice, export dos, you need a sharp programmer, what is record in data structure, what is data structure in programming, what is data structure in c, what is data structure, what is data in data structure, what is a data structure in c, what is a data structure, what data structure, what are the application of data structure, what are data structure, type of data structure in c, type of data structure, tables in data structure, table data structure, programming with data, programming in excel 2010, programming in data structure, programming in access database, programming in access

İşveren Hakkında:
( 0 değerlendirme ) toronto, United States

Proje NO: #686735

Seçilen:

iamsupriyo

This could be done.

8 gün içinde 100$ USD
(1 Değerlendirme)
1.0

8 freelancer bu iş için ortalamada 140$ teklif veriyor

Jia21

Well, you might not need to provide me your existing database. Or i can do the merge for you. Depends how to set up your primary key. We can dicuess about this.

in 2 gün içinde80$ USD
(1 Değerlendirme)
1.0
Honsoft

Read your PM Pls.

in 10 gün içinde100$ USD
(0 Değerlendirme)
0.0
Morphe

Toronto boy now living on the West Coast. I am a long time programmer(1971) with experience in over 2000 jobs like this. It is simple. There will be no data loss and there is will documentation provided on the process Daha fazlası

1 gün içinde 200$ USD
(0 Değerlendirme)
0.0
paleboyeh

Hi there, Please do not be surprised but happy . I have just finished implementing what you requested because I did the same job years ago when I was working for my ex company and had to reprogram a set of qbasi Daha fazlası

1 gün içinde 190$ USD
(0 Değerlendirme)
0.0
jtbanks

I am an developer who work on Database for personal and small business What i do is create the Database, tables, query and file using vba to create the look and feel that each customer wants. I also provide a servi Daha fazlası

in 7 gün içinde150$ USD
(0 Değerlendirme)
0.0
usenkoko

Hi! I have experience in development of business solutions. I developed project by MS FoxPro (in 1997). Usually i have experience in Access.

in 20 gün içinde150$ USD
(0 Değerlendirme)
0.0
FirstOption

It can be done in MS Access. Please refer my private message. Thank you.

in 5 gün içinde150$ USD
(0 Değerlendirme)
0.0