Search results

Well what would I do if I had 240 .csv files that need importing? I would have to agree that several would imply 3 but I have rainfall data for the past 5 years at six locations. None of the files have commas in them but I could see how that would pose a problem.

Thanks for the quick reply. I don't understand what you mean by "call it 3 times". Does this mean that I need to have a specific name for the Specification Name? I will look into the table where I'm sending the .csv files, it was previously set up for excel files and I'm not sure if I need to...

I still do not know how to structure the code to import a .csv file. So far I have, DoCmd.TransferText acImportDelim, "", "tblTmpLoadXls", "C:\Users\UserName\Desktop\CSV Converts\", False Obviously the actual code doesn't have "UserName" but you get the idea. Why doesn't this work and what...

I'm fairly certain this should be an easy one for the forum. I would like to know the code I should use to import several *.csv files into one temporary table. I suppose a simple import code would work. Thanks.

Does Access see the text files in the same way it sees the excel files. Meaning, from Access' point of view, is there any difference?

I have tried to delete the 4th plus column. The original excel file did have more than the three columns, the code for Private Sub cmd_process_xls_Click() has a section where it is supposed to delete the 4th and 5th coumn. If I cut and pasted the three coumns I want into a new excel file and try...

I also wanted to post the code that is associated with my problem. The first set reformats the data into the 3 column format I mentioned earlier and then the second is supposed to import all the reformatted excel files into a table. Private Sub cmd_process_xls_Click() On Error GoTo...

I would but apparently I can't upload a .xlsx file, I'll post it in .xls but I don't know if that would change anything. I also uploaded the next excel file as well because when I upload in access it does import all of the first file, maybe some of that made sense.

I have been trying to add several excel files into one table in access but as the files are being imported access always hangs up on one file. All the excel files are the same version ('07, so is access) and they all have 3 columns. Access hangs up though on this one file telling me that field...

I thought I would post the entire set of code... Private Sub cmd_process_xls_Click() On Error GoTo Err_cmd_process_xls_Click ' Switch off all the WARNING msgs. DoCmd.SetWarnings False Dim strXlsFileName As String Dim XlsPath As String Dim WBname As String Dim Trimname As String Dim...

Now I'm getting the same error message about the saving method failing.

No, though I may have found the solution and it lays outside of the code I posted. A couple "DoCmd.SetWarnings" where in the code with the incorrect version of true/false after them. That may have been the problem but if anybody else sees an issue please let me know.

I was tasked with debugging code and stummbled across this error message "Method 'Save' of object '_Workbook' failed" Here's the portion of the code that pertains to this... Set TestBook = Workbooks.Open(XlsPath & strXlsFileName) Set TestSheet = TestBook.Worksheets(1) '...