Export from Access 1.x (!)

[G. Telemann]

Hi Experts,

I still have some small ancient Access 1.x Databases... Which tool can
export the tables without using an ancient or newer Access Version?

TIA Georg

 

[Jens Schilling]

HI,

I still have some small ancient Access 1.x Databases... Which tool can
export the tables without using an ancient or newer Access Version?

The common language here is german ;-)

--
Gruss
Jens
______________________________
2. SEK (SQL Server-Entwickler-Konferenz)
Nürnberg, 12./13.4 und 19./20.4.2008
FAQ: http://www.donkarl.com

 

[Henry Habermacher]

Hi G.

I still have some small ancient Access 1.x Databases... Which tool can
export the tables without using an ancient or newer Access Version?

You should be able to read the tables for examply by MS Query (part of
Office) but you may also use VBScript for this task and read these by
programming against the DAO library that should be able to open even A1.x
files

For the next time you should not post into a german newsgroup if your
language isn't german. There are many english newsgroups to post your
questions.

TIA

Henry

 

[Alex Dybenko]

Well, I don't have access 1.x database around to try, but believe you can
use access 2003 to import tables from there.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Henry Habermacher]

Hi Alex

Well, I don't have access 1.x database around to try, but believe you can
use access 2003 to import tables from there.

IIRC A2003 can even import Access Objects from 1.1, but may also be 2.0. But
content of tables you should be able to read even in A2007.

Henry

 

[G. Telemann]

I still have some small ancient Access 1.x Databases... Which tool can

export the tables without using an ancient or newer Access Version?

I just need a *fast* solution that generates a standard data format
(CSV, dBase or any other) that can be easily converted into other
non-Access formats... Is there a solution that does not require Access?

TIA Georg

 

[Alex Dybenko]

Access is a fastest solution
few clicks and you have csv of dfb file

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Tony Toews [MVP]]

I just need a *fast* solution that generates a standard data format
(CSV, dBase or any other) that can be easily converted into other
non-Access formats... Is there a solution that does not require Access?

Try using Excel to open the database.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[aaron.kempf]

have you tried SQL Server DTS? or SSIS? or any other commercial grade
ETL tool?

Access isn't a real database; in case you didn't get that memo

-Aaron