Recent content by datavisions

I have code that will find the number of .TXT files in a folder. I normally only process the one that is usually found in the folder, but I need to know how to process as many .TXT files as are found. Has anyone done this before? Here's the code I use to identify ONE in the folder. Public...

I used to manage hockey! I have another question about importing so I'll post a new thread here in a sec.

Ignore me. That won't work. I better get some rest now.

You can try Set variableX = 5, but that will make an assumption about the data type, if that's OK.

Mike: I tried and it would even compile LOL (but then we all know the kind of day I'VE had)

mike777: You sure have a way of calming down a hysterical programmer-in-distress with your demeanor. Thanks a million!

scriverb: I'm in beautiful Toronto, Canada. Great selection of beers here.

I GOT IT! No syntax errors, and it INSERTS perfectly. Here's the full SQL (I had narrowed it down to two fields for simplicity earlier). The trick is to put SINGLE quotes AROUND the double quotes, like: '" & variable & "' so here's my new code: db.Execute "INSERT into...

I GOT IT! No syntax errors, and it INSERTS perfectly. Here's the full SQL (I had narrowed it down to two fields for simplicity earlier). The trick is to put SINGLE quotes AROUND the double quotes, like: '" & variable & "' so here's my new code: db.Execute "INSERT into...

scriverb: I'm not getting a syntax error any longer, BUT nothing it making it to the table. No message, nothing.

scriverb: Yes that's what it looks like

Mike777: I tried: I would say: db.Execute "INSERT into tblAAAccidentTemp(OldAccountNumber,RejectCode) values ('123456789111','SomeString30CharactersLong')" or: db.Execute "INSERT into tblAAAccidentTemp(OldAccountNumber,RejectCode) values...

scriverb : That's correct. It's like a "remarks" field. Sometimes it has text in it, and sometimes it doesn't.

mike777: I'll try that right now and let you know. I REALLY appreciate everyone's help and I hope I get through this.

jiqjaq : I had tried that as well, since that's the way I used to always do my SQL. It still didn't work. That's why I've been going mental over this today. Nothing seems to work.