Recent content by rpenman

Access 2007.

This will be an ongoing process I am trying to automate for my company, basically an excel spreadsheet is generated from SmartOffice, the data needs to be modified and then imported into a pre-existing database in Access. The director wants other departments to now do this on thier own so she...

I have a Excel Spreadsheet that has column B that is Last Name, First Name but I need to see if there is some code or function that will take the data from that table and create a Last Name column and place the last name and keep the first name in the original column and change that column name...