Search results

Nvm I figured it out. Column Count = 1 Column Widths = 3"

Neither of those worked. I have over 46 fields in my table.. so to keep it simple this is what I have. FileName, DatabaseID (primary key) rcokrons_20180719@1603, 12 rcokrons_20180719@1603, 13 rcokrons_20180719@1603, 14 rcokrons_20180720@2000, 15 rcokrons_20180721@0600, 16...

I am operating in the SQL View of the Query builder. I have a list box on a form that is pulling values based off my query. The problem is I have several duplicate values. For instance, when I import files using a form, I have a column in the table update with the file name for every record that...

I understand what you are saying. The very first time I tried it I omitted the 1st character and the compare options. Did not work. Then I added the 1 option without the compare options. Still didn't work. Then i used the 1 option with the TextCompare, still didn't work. Then I used the 1 option...

Whenever I tried it with the Compare option it would not work correctly. As soon as a put in the Compare option it is only importing files with the file name "rcokrons" in it, Which is what I'm looking for.

Thanks I got it. If InStr(1, Me.txtFilepath, "rcokrons", vbBinaryCompare) = 0 Then

It's not working. Whether I do it how you referenced above or "<> 0" or "> 0" or "< 0" it still can't tell the difference. Btw I did read the URL that you posted. That's where I came up with the initial code. lol

C:\Users\carterlw12\Documents\Audits\Rcokrons\rcokrons_20180718@1535.csv This is what is in my txtFilepath.

So I've tried to get this working a couple different ways but I think my beginner status is showing through.. lol I'm getting the MsgBox to show up even though my txtFilePath does have the word "rcokrons" in it. Private Sub cmdImport_Click() Dim FSO As New FileSystemObject Dim strSQL As String...

Yes. I have actually changed the field names and characters instead of leaving them as reserved names and characters! Thank you!

I did. I looked up reserved words, because I didn't know all of them, and changed all my field names in the tables and VBA code. All is good! Thanks.

Is there a way during my import that I can specify that it only imports if it matches a certain word in the file name? I'm using: Private Sub cmdImport_Click() Dim FSO As New FileSystemObject Dim strSQL As String strSQL = "INSERT INTO PeopleSoft_Import_tbl (GlobalID, RecordEffDate, BirthDate...

It was ft/pt, reg/temp and union need brackets around them

Ahhhhhhh it was the "union". I didn't realize that was "illegal". That worked!!! Thank you!

I tried that. Same error "3134 Syntax error in INSERT INTO statement".

Sorry, I don't know how to do that. lol

Importing into staging table using a form button and it's successful but inserting that into the actual table that I want the data to reside in is not working. I'm getting syntax error for my INSERT TO statement. Private Sub cmdImport_Click() Dim FSO As New FileSystemObject Dim strSQL As String...

Here is my entire section of code. Everything is working except the insert into the new table and then of course clearing out the staging table afterwards. Private Sub cmdImport_Click() Dim FSO As New FileSystemObject Dim strSQL As String strSQL = "INSERT INTO ADP_Person_Import_tbl (GlobalID...

I am getting an error "Run-time error 3134: Syntax error in INSERT INTO statement." I can't find anything wrong with it per your example. Here is my code. CurrentDb.Execute "INSERT INTO ADP_Person_Import_tbl(GlobalID, RecordEffDate, BirthDate, HireDate, ReHireDate, ServiceDate, SeniorityDate...

I haven't been able to try this today but I will definitely give it a shot. It should work obviously, I just have to make it happen. lol thanks for the help. I'll be back if I need any more.