Does anyone know if it is possible to transfer data from an old MSDos database into an Access 2003 one?

If so any idea how you would go about doing this?

Thanks in advance.

if you can get the data in txt, csv, xls then yes
dump data into one of these formats and then use the import wizard
you might need to mess around with this a bit - but all do-able - you may lose a bit of formating if you are not carful so check each column .


g

Thanks. Any idea how I can export the data into an xls or csv format? I know nothing about how MSDOS works.

can you see any of the structure ???

how big is the data source??
this could be one for the experts

g

MSDOS was an operating system. Do you know what database software was being run?

Once I converted an MSDOS db that used a proprientry db format, and I used DbaseV to parse out the data . Took me 80 hours work as each record was variable in length and some empty fields had a marker and some did not. It was a nightmare!

MSDOS dbs :- DBASE, Clipper, FoxPro, RBase, Dease, all of these had a decent development environment so you could export data as CSV files. What is are the file extensions of the db files.

Thanks for your replies. I had a feeling this wouldn't be easy.

The DOS database has approx 20,000 records in it. I don't know how to view the structure. I really do know nothing about it!

It uses a .bat file to open it but as it's loading the following text appears:
Reading .LBL file Does this mean anything?

It is going to be a complete nightmare due to formatting, field lengths etc. I'm almost considering transferring all the data manually but that will definitely be a last resort.

Cheers

have a look at this site

http://filext.com/file-extension/LBL

If all else fails you will need to use a hex viewer to determine the structure.

do you know how many fields there are - as a starting point - I would import everything as memo fields and see if from this you can decifer what the flipflop is going on -

ie any field with less than 255 char then convert to text, any that are numeric etc - this could be a long job - glad its you doing it and not me ..
g:rolleyes:

It uses a .bat file to open it but as it's loading the following text appears:
Reading .LBL file Does this mean anything?


Can you post the batch file here so we can see what it contains.

You may want to take a peek at the file in notepad or wordpad to see what the structure looks like...

ken:)

As an alternative, you might try DBFviewer . Assuming the dbase is Dbase IV or Clipper. With this tool you may edit or transfer data from yours to another Database format.
Here's the link :

http://www.filedudes.com/DBF_Viewer_2000-download-15952.html


Btw,
Hello Ken, long time no see. How's the weather in Atlanta ?

Btw,
Hello Ken, long time no see. How's the weather in Atlanta ?

Thanks for asking - Good. We're finally getting some long needed rain. (But now I have to keep the grass cut :))

I've been thinking about this and I think trying to transfer this is going to be more trouble than its worth. I think manually inputting the data is going to be much easier. If I start today I should be done by 2012... :-)

Thanks to you all for your advice on this, I really appreciate it. I'll let you know if I do decide to take this further.

P.S. I have another post titled Label Wizard/ Printer problem if anyone wants to take a look. It might save a printers life. It nearly went out the window 10 minutes ago...

Cheers

How small is the file when you zip it? Can you post it and let me take a look at it?

I can zip the batch file but it has no data stored in it when I do. Does that matter?

Sorry if I sound stupid but I know nothing about this sort of thing. As you can probably tell....

The original 'MSDos database' has no data in it?

???
ken :)

No that's got about 20,000 records in it! All I can find file-wise is the batch file to access it. I can't find the actual database, don't know where it's located. That's half my problem.

Can you post the text from the batch file? Just open it with Notepad and copy it here.

Or can you print it to a file? What options do you have when it comes up?

I get the following text when I open the batch file in notepad:
cd\andrew
G:\util\ inner4 andrew

andrew is the name of the batch file. G:\util is the drive & folder it is stored in. There is also a .DBN & a .IDX file named inner4. Could this be it??

What are the file sizes?

The .DBN file is 875 bytes and the .IDX is 21 bytes.

I doubt those have any data in them...

I'm guessing your're working with a dbaseIII file. Can you scan (search) your g: drive for .dbf files?

inner4 must be an executable file or another batch file, but I don't know what.

I get the following text when I open the batch file in notepad:
cd\andrew
G:\util\ inner4 andrew



Inner4 sounds like your connecting to a Unix system. Maybe AS400 or similar ?

I scanned the G drive and there are no .DBF files at all.

I assume you've asked around and nobody knows squat about the database, even maybe someone in IT? Surely the net work admin can point you to someone. Who did you come to get the shortcut?

We know less than squat. This database has been going for years. Long before mine or anyone elses time. Last I heard the person who built it had moved to a remote part of Australia. With good reason I think....:-)

If I find out anymore I will post back here. Meanwhile I've got that printer problem to fix.

Thanks for all your help anyway. I really appreciate it.