Importing a .txt file into an access2003 table

[Guest]

i have a text file on a web site
"http://www.easy-to-use-databases.co.uk/Databases/Job_Manager/Job_Manager_Revisions.txt"
and a table in access2003 named "tblImportedDatabaseVersion". When the user
clicks a cmd button the text file is downloaded from my site into the table
so that i can manipulate it.

Been trying to use the transfertext function but just cant get it to work.
Can anybody help please?

 

[Brendan Reynolds]

I just posted a suggestion in the thread you already have going on this in
the microsoft.public.access newsgroup.

I'd be very surprised if the TransferText method worked via HTTP or FTP, I'd
expect it to work only with files on your physical network.