Can any one tell me how to convert the MDB to TextFile and Textfile to MDB?

Mmmmhhh, I wonder if you can...

____________________________
Real Programmer can count up to 1024 on his fingers

Hi,
The MDB is a heavily structured file, you can export text from it, and import text into it, but as far as I know, no-one has (bothered) to crack the file format.
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

It can be "converted" as in you write a program to open up every single table, export the info to a file; or open up a file, and insert it into a database.... but otherwise, a "convert" thing isn't exactly possible I wouldn't think. (other than the export/import)

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

Ok! if somebody can tell me how to import and export the MDB into a file and vice versa.

OK... here it is

How to export data from MS-excel to other program or format:

Open MS-Access program => open your .MDB file.
Select a table (click on a table)
File => Export
Type file name
Change SAVE AS TYPE (either text or anything you want)
click EXPORT

regards,


shahid mojid

Opps... sorry to write how to import data from text files to Access file. Here it is:

1. Open MS-Access program
2. Open a database file where you want to get your data
3. File => Get External Data => Import =>
    select location
    Change FILES OF TYPES
    Select the file and click IMPORT

Wish you all the best

Shahid