Search results

I currently have 2 tables in a database that I'm trying to build a query off of. The first table lists personnel & their position #s, and the second table has a column for "rated person", "rater", "senior rater" and "reviewer" which are all part of our annual evaluations. I'm trying to program...

Text to Columns in VBA returning "Object does not support this method" error I am trying to format an excel spreadsheet through access, specifically trying to convert a column from text to dates (I receive the data in text format and need to translate it to dates). Dim excelApp As Object Set...

I am trying to format a spreadsheet to import into a Table. To do this I need to delete the top 8 rows and then the 4 rows below the data I need, both areas contain header data. The 4 rows below the data I need are blank but formatted oddly and it is causing issues during import. I'm a complete...

[SOLVED] Converting text date to date date during import I am building a database using data imported from Excel workbooks. The dates in the workbooks are formatted as text in the YYYYMMDD format. Is there a way to convert this into date format during the import or after? I am pulling in a lot...

Hello all. I use Access at work (does anyone use it for fun?) mostly to try and track data from many different sources and provide my bosses the information they want in a way they can understand it. I wouldn't say I'm a novice, but I'm certainly not advanced, mostly I have learned by...