Search results

I have several imports that I will be doing every week. Some are excel, some are text files. I need to import the file, delete the data in the existing table, and copy the new data in. I've figured out how to do it with excel, but I'm stumped with .txt files... Can I somehow modify...

(MS Access 2010) I am sure this should be so simple, but I can't make it work... I am trying to calculate the next due date for an inspection using a query. The two fields I am pulling from my table are: [LastInspectionDate] and [InspectionFrequency]. The inspection frequency is...

I download an excel spreadsheet from an outside source, and it comes in with a space before the data in column A. I need to remove this space before I import into my database. I used this code in another function, and it worked perfectly. For some reason, I am getting an "Invalid Use of...

Have an excel sheet that I want Access to open, delete the first 2 rows and then sort (remove all rows where column C does not equal "A0C6") I can get the sorting code to work in excel, but not access. I believe the bolded row is where I am getting the error. Would appreciate any help...