Discussion:
Export from Access 1.x (!)
(too old to reply)
G. Telemann
2008-03-20 06:12:13 UTC
Permalink
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
2008-03-20 06:54:06 UTC
Permalink
HI,
Post by 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?
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
2008-03-20 09:01:17 UTC
Permalink
Hi G.
Post by 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?
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
--
SEK2 Anmeldung: http://donkarl.com/?SEK
Microsoft MVP Office Access
Keine E-Mails auf Postings in NGs. Danke.
Access FAQ www.donkarl.com
Alex Dybenko
2008-03-20 09:19:33 UTC
Permalink
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
Post by 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
Henry Habermacher
2008-03-20 09:53:30 UTC
Permalink
Hi Alex
Post by 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.
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
--
SEK2 Anmeldung: http://donkarl.com/?SEK
Microsoft MVP Office Access
Keine E-Mails auf Postings in NGs. Danke.
Access FAQ www.donkarl.com
G. Telemann
2008-03-22 13:36:49 UTC
Permalink
Post by 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
2008-03-22 14:24:27 UTC
Permalink
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
Post by G. Telemann
Post by 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
Tony Toews [MVP]
2008-03-22 19:08:45 UTC
Permalink
Post by G. Telemann
Post by 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?
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/
a***@gmail.com
2008-03-24 09:24:48 UTC
Permalink
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
Post by G. Telemann
Post by 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
Continue reading on narkive:
Loading...