Export from Access 1.x (!)

Export from Access 1.x (!)

Post by telli » Fri, 21 Mar 2008 15:12:13


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
 
 
 

Export from Access 1.x (!)

Post by Jens Schil » Fri, 21 Mar 2008 15:54:06

HI,



The common language here is german ;-)

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

 
 
 

Export from Access 1.x (!)

Post by Henry Habe » Fri, 21 Mar 2008 18:01:17

Hi G.



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://www.yqcomputer.com/
Microsoft MVP Office Access
Keine E-Mails auf Postings in NGs. Danke.
Access FAQ www.donkarl.com
 
 
 

Export from Access 1.x (!)

Post by Alex Dyben » Fri, 21 Mar 2008 18:19:33

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://www.yqcomputer.com/
http://www.yqcomputer.com/
 
 
 

Export from Access 1.x (!)

Post by Henry Habe » Fri, 21 Mar 2008 18:53:30

Hi Alex



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://www.yqcomputer.com/
Microsoft MVP Office Access
Keine E-Mails auf Postings in NGs. Danke.
Access FAQ www.donkarl.com
 
 
 

Export from Access 1.x (!)

Post by telli » Sun, 23 Mar 2008 22:36:49

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



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
 
 
 

Export from Access 1.x (!)

Post by Alex Dyben » Sun, 23 Mar 2008 23:24:27

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

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

Export from Access 1.x (!)

Post by Tony Toews » Mon, 24 Mar 2008 04:08:45


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.yqcomputer.com/
Tony's Microsoft Access Blog - http://www.yqcomputer.com/
 
 
 

Export from Access 1.x (!)

Post by aaron.kemp » Tue, 25 Mar 2008 18:24:48

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