Software

Ask something
Discussion Locked

Importing Excel Worksheet to Access

0 helpful
3 replies

by girja.boru

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by dklippert

Add a couple of columns to the right of the Customer Name column in Excel.
Select the Customer name column and choose
Data>Text to columns. It will be Delimited so click next. Put a check mark next to the correct delimiter, Space or Comma. Then click finish.
Rename the fields and carry on.

This discussion is closed to new replies.