Search results

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...

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'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.

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 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) '...