Recent content by DJ_Hardin

Thank You! This does just what I need! (My last hang-up was siimply that I accidently had a ' instead of a " !)

Based on what lagbolt warned, a "string" doesn't work for the path name, so the blue text (mypath & objWkb) was replaced with the full path and file name (G:\DataFolder\DataFile1). Before doing this replacement, I confirmed that lagbolt was correct in predicting that the blue text would cause...

I tried this, and got a run time error "expression entered is wrong for one of the arguments".

I tried this, but it made no difference -- Sheet1 is copied over many times. I think it is looping through for as many sheets as there are, but the import range is staying as Sheet1!c2:Q17281 even though I have never specified Sheet1.

Well, I was able to import the appropriate range without the sheet name -- but it only imported the first sheet, and I want to import all 30 sheets in the Excel file into one Access table . . .

Yes, the column headers are the same (although I'm not inporting the headers). The data types of the columns are also the same across all sheets.

Thank you, with your help I was able to get the code to run (I dealt with your blue text by inserting the full path and filename). I also checked out the Object Browser -- definately a good tip for me. BUT, the code doesn't do what I intended. Instead of importing each of the 30 sheets into...

My apologies in advance for inquiring about something that I see many similar post on. I am trying to import data from an Excel workbook into a single Access table using a mix of code from several threads. My Excel workbook has many sheets, but thankfully, I need the same range from each sheet...