Is there a quick easy way to make two tables from one?

[rpenman]

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 from Last Name, First Name to simply First Name.

 

[Kryst51]

You are wanting to do this in the excel spreadsheet? Or import the information into Access? Is this a one time deal or something that you need to do often?

 

[rpenman]

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 tasked me to automate the process. I see that I can manually enter in a new column and then click the text to columns button and it does it, but I wanted to see if I can get this to be done by some action or macro. Thanks for the quick response.....

 

[Kryst51]

What version of access are you using?

 

[rpenman]

Access 2007.