Search results

Thanks very much for your help everyone. I think this will have to be something that I edit manually before importing.

Yes, I have been playing around with it, but can't make it work. I am new to VBA - I'm still at the "google an example, and edit it to suit me" stage. Can't find an example to copy. LOL

I feel that I may have not explained myself clearly. Is there code that I can write to import a text file via VBA? I don't want to use the wizard, as the text file requires some manipulation before it imports (need to delete a row, which I want to write into the code). Ideally, I'd...

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

Thanks - I had tried "yyyy" - but I had it backwards, so it didn't work. I KNEW this should be an easy fix! ☺

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

Thanks very much Galaxiom. Appreciate the tips. ☺ Still haven't figured out my original issue. LOL

That deleted all of the data in the cell?

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

Got it! Thanks again!!!!

Thank you, thank you, thank you!! It is working!! I've run into a small snag, though. The spreadsheet that I am downloading has a number (stored as text to preserve leading 0's) in the first column. Unfortunately, it also has a space before the number. Is there a way to delete the space...

You are right - sorry, I missed a bit. Here is what I have now: With oBook.Sheets(1).Range("C2", oBook.Sheets(1).Range("C" & oBook.Sheets(1).Rows.Count).End(xlUp)) And I am getting this error: Application-defined or object-defined error

Thanks for your help - I really appreciate it!

With oBook.Sheets(1)("C2", oBook.Sheets(1)("C" & oBook.Sheets(1).Rows.Count).End(xlUp))

Hmm. Getting this error: Object doesn't support this property or method

Can you please tell me how to reference the Excel sheet? I'm a VBA novice. :)

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