Importing A Text File

**steve2507** · 02-27-2012, 05:40 PM

Hi,

I'm trying to import a text file (semicolon delimited) into a table using the following code:

Code:

DoCmd.TransferText acImportDelim, , "tmp-orders", "url", True

However I get the error message

The file does not exist, or you do not have read access to the file

The file is on a website and is there (I can view it in a browser).

Does anyone have any ideas?

Thanks

Steve

**June7** · 02-27-2012, 06:58 PM

url is a variable set in code? Don't put variables within quote marks.

**steve2507** · 02-27-2012, 07:03 PM

Just found out that Access can't take the text file from a website so have managed to get it working by manually downloading the file.

Now on the lookout for a way to automatically download the file in question.

**steve2507** · 02-27-2012, 07:05 PM

Sorry June7, thank you for the reply.

The url is a variable but isn't in quotes in the sub, I added the quotes to make it show that I knew the actual filename had to be in quotes.