Can you Import a .txt file from website

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a .txt file on my website that contains order information. Is ther a
way to import this file to access then distribute the info to the desired
table and within that table seperate the txt strings to the desired colums.
Example
date, invoice#, firstname , Lastname ect;?
Thanks in advance. By the way you guys have tought me alot about access and
the possabilities. Thanks so much to all of you !!!!!!!
 
Alvin,

I have several text files that I update from websites on a weekly
basis.

My technique is to 'link' to the text file,
( File > Get External data > Link Tables >

I then use a query to name the fields to suit my database.

Cheers,

Robin Chapple
(Still learning)
 
Start with your text file in a realistic folder:

C:\MyData\Orders

Call the file orderinfo.txt

From your database go to >

File

Go to

Get External data

Go to

Link Tables

and then navigate to your file:

C:\MyData\Orders\orderinfo.txt

Follow the prompts and you will have a table in your database named
orderinfo.

Open a query on the table "orderinfo"

The field names will be Field1; Field2 etc.

In each field in the grid enter your preferred field name followed by
a colon followed by the assigned field name:

"MyChosenFieldName:Field1" and so on.

Give the query a meaningful name.

Robin Chapple
 
Back
Top