Search results

no answers, really?

How do I autofill numbers in an Excel file if I want it to stop at the first empty cell? I am trying to format multiple Excel files through Access. The Excel files already have numbers in the field but I want to change them because from the source the numbering starts at 0 and not 1. All I want...

Sorry for the continual posting but I want to keep you guys updated so that we don't run circles. I created a fourth column in the temploadxls table since the error I kept getting was about how the data being imported needed one. I figured that I could see what was in this fourth column. There...

Though I will most likely not use the code you provided I am a little interseted in how to write SQL statements. I noticed that I got an error when I tried to use your code with my copy of my database that is in .csv format and when I debugged the code this line was highlighted: db.Execute...

What would the code look like if I used excel files?

F1 date/time (general date) F2 text F3 text I hope that's what you wanted.

New question, same topic. I've got the same data set I've been working with but now they're in .xslx. I heard it through the grapevine that Access doesn't like the date/time format to be "mm/dd/yy hh:mm:ss.0" with the .0 portion denoting half second marks. The archaic program we use in the field...

Thanks a lot, it's not the answer I wanted but that makes perfect sense.

Is it possible to have half seconds in access like it is in Excel? I assumed so but everytime I try to import a .csv file (they were Excel files a while ago but that's a long story) I get a type conversion error. I have been into the design view of the table where I'm importing the csv's and...

I suppose its a common error that been hashed out several places. My problem now is with the data once it is imported. I moved from excel files to .csv's to avoid blank spaces in my table and other unwanted small things. All I wanted was a list with no gaps of all of my data. Why would the table...

Wow I just put my foot in my mouth. The file path was incorrect *sigh*. Though this led to a new problem. It loaded some of the files, not nearly all of them and the ones it did add it added twice. The error that stopped the import process said there was no F4 field. There shouldn't be a fourth...

Really dumb question, where is it supposed to print? I put the extra lines of code in but there was no change in what happened. Also, how can there be no files that me the criteria. From what I see, and I guess I'm wrong, all the files have to be are in the directory that I specified in the...

With that variation I get no errors and an empty table. I also have a semi blank msg box with that too, the box that is supposed to display 'MsgBox "Csv Name " & strFileName'. In the original code the do cmd was DoCmd.TransferSpreadSheet acImport, acSpreadsheetTypeExcel9...

I fixed the problem with the code below but now it says that Access cannot find the first file that it needs to import. Private Sub Cmd_Upload_Data_Click() On Error GoTo Err_Cmd_Upload_Data_Click ' Switch off all the WARNING msgs. DoCmd.SetWarnings True Dim strFileName As String Dim...

When I do that the msg box that is supposed to have 'strFileName' which is supposed to represent Dir(cstrPath & ".csv") comes up blank. The tempLoad table is also still blank after the code runs, although I don't have any errors now.

Don't I already have a l_strFile typr parameter in the code with the cstrPath as the directory where the files are that I want to import. That is an input by the user, couldn't I call on that instead of making a new one within the code? or am I missing the point completely? I made these changes...

Does anyone know why I get the 'Invalid Argument' error when I run the code that I last posted?

Thanks for your help thus far, sorry I'm being thick. I noticed that I had a *.xlsx still the in the code I was using. After changing that to a *.csv I got an error, "Invalid Argument". I figured I'd pass the code on to you and see what you think. Private Sub Cmd_Upload_Data_Click() On Error...

I will take me a while to digest what all that code is doing. I honestly thought this whole mess would be solved in one line. Could you quickly run down what exactly that code is doing in layman terms?

I'm borrowing from the previous excel import code but is this what you mean? DoCmd.TransferText acImportDelim, "", "tblTmpLoadXls", "C:\Users\UserName\Desktop\CSV Converts\", False, txt_box_file_path & strFileName strFileName = Dir() I hate to keep asking the simple but as I'm sure you've...