Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 09-23-2002, 10:22 AM   #1
LQ Newbie
Registered: Jun 2001
Posts: 5

Rep: Reputation: 0
convert text File to Access MDB

My problem is simple, but very particular : I am looking for a Linux application or a script which can convert a text file to an Microsoft Access File.
I have already visited several web site, but unsuccessful.

Who knows a site where I can find this kind of Application.


Old 09-23-2002, 12:02 PM   #2
Senior Member
Registered: Aug 2002
Location: Groningen, The Netherlands
Distribution: Debian
Posts: 2,536

Rep: Reputation: 111Reputation: 111
Supposing you have the textfile on a Linux-PC (this is a Linux-forum after all...), you could try to do something like:

(1) Convert the text file to a Comma-Seperated format (which usually has a .CSV extension if remember correctly) using "awk", "sed", "perl"....

(2) convert the resulting tekstfile to DOS/Windows newline format with the "unix2dos" utility.

(3) transfer the file to the windows-PC (diskette, harddisk-swapping, or using a network (samba, ftp).

(4) Import the file in MS-Access. MS-Access should be able to read these comma-seperated files (if contructed correctly in step 1 )
Old 09-24-2002, 05:42 AM   #3
LQ Newbie
Registered: Jun 2001
Posts: 5

Original Poster
Rep: Reputation: 0
Thanks Hko for your answer,
My text file is already in a Comma-Pipe format, but I use a automatic process on Linux and that is because I need this kind of application.
I have to provide a MDB file without using windows!



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access (mdb) file reader? logosys Linux - Software 2 08-31-2005 02:33 PM
read/write in *.MDB (MS-Access file) form Linux FC3 thuan1975 Linux - Software 1 08-11-2005 01:25 AM
convert text file to binary excel file ust Linux - General 2 11-23-2004 02:33 AM
convert error messages to text file creilar Linux - Newbie 1 05-26-2004 10:58 AM
how can I convert a text file to a html one? kevin_liu Linux - Software 2 07-16-2003 06:09 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:21 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration