Importing Text Files

  • Thread starter Thread starter Sikiru Olusanya
  • Start date Start date
S

Sikiru Olusanya

Dear reader

I am working with a text file. This file is in a report
format. Names Address Age and other information. The data
is separated from one another by space and not comma.
Please does anyone knows how to import this file to access
database table?

Thanks
 
Open Access & select Import a New Table, Select From Files
of Type "Text Files". Select the text file containing your
data followed by IMPORT. The import wizard is now
displayed, select the format "DELIMITED". Now select the
next button & on the next screen select the radio
button "OTHER". Press the SPACEBAR as the character to
seperate the fields & follow the Wizard through to the end.

Charlie
 
I have had this same issue. I parsed the data in Excel using the DATA, TEXT
TO COLUMNS feature. This lets you key on a space. After you get the data
into Exel formatted, the export to access should be easy.
 
Sikiru Olusanya said:
Dear reader

I am working with a text file. This file is in a report
format. Names Address Age and other information. The data
is separated from one another by space and not comma.
Please does anyone knows how to import this file to access
database table?

Thanks
Click to expand...

Take a look at

http://www.delphipages.com/result.cfm?ID=4743

with this utility you should be able to import datas in any database.

Tazio.
 
Back
Top