Search results

I tried something different this moringing. Private Sub TransferSpreadsheet() On Error GoTo Err_Command1_Click DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Matched Ad Costs", _...

I actually have 15 or 16 different excel files that need to be imported into different Access tables and wanted to set up a quick way to import them. My problem is that each excel file name ends with a date and time stamp. I had added this to a form that kicks off several macros but I keep...

Sorry, New to this and I posted it under modules but noticed there weren't as many people in that forum as general so i wanted to post it where I might get a faster response. I have already spent a couple of hours trying to figure this out and am getting increasingly frustrated.

I need to import an excel file every week into Access. The file is always saved in the same folder called "Current" however the file name changes week to week because of a date and time stamp. For example this week the file is named: Weekly_Internet_Order_Matchup_Converted_Channel_Su...

I need to import an excel file every week into an access database. the file is always saved in the same folder called "Current" however the file name changes week to week because of a date and time stamp. For example this week the file is named...