Search results

Thanks for the reply. I made a bunch of edits to that last post, I even confused myself while rereading it. I apologize! Here is my code right now: Dim i As Integer Dim strPathAndFile As String Dim strHold As String Dim strSQL As String strPathAndFile = "P:\test1.txt" i = FreeFile Open...

Greetings: I am trying to import text line by line (it's html source code), but access imports it out of order if I use the import tool, so I am running code that will paste it line by line. I have most of the code finished, but the text file i wish to import has apostrophes in it, which won't...

I believe the syntax error was due to it not being a single ' since it was bringing in text. However, it's still not looping through the lines of the txt file correctly. It's only inserting the last line. EDIT: That's not it either. Heh. It appears to run for the first few lines then shoot back...

Sorry it took me so long to respond. I've implemented the changes and I'm getting an error: Syntax error in string in query expression, and then it gives me the source code in the error box.

Thanks for the reply. This line is reading as an error, and I cannot figure out why: strSQL = "Insert INTO TableNameHere ([FieldNameHere]) Values (" Chr(34) & strHold & Chr(34) & ")" It's getting an expected end statement error.

Hey everyone! I am trying to set up an access button to go to a website, download its source code and import that txt file into a table so it can be parsed. Nothing too fancy, right? Well, when I go to import this text file, it imports that data in a weird inconsistent order. The problem is I...

That's a solution too. Ideally it's nice to keep everything clean on an access form, but if I have to do that, I certainly will. I'm up for any and all suggestions.

Greetings: I'm trying to create a small program that makes one particular job my company does significantly easier. The software our client uses is obnoxious which involves a lot of clicking through their web interface to view documents to audit. It can be up to 1000 documents to audit, and each...