I have an Excel worksheet that has one field that is defined as Customer Name. I want to import this field to Access97 as two fields, such as “Cust Last name, Cust First name”. What is the quickest and efficient way for me to do this?
Thanks in advance.
