Excel to Access

  • Thread starter Thread starter Deborah
  • Start date Start date
D

Deborah

I have a mailing list that I would like to convert to
Access. I'm following the directions from the assistance
center website but it won't bring up the actual data. I'm
attempting to make mailing labels.I doesn't take me to
the import spreadsheet wizard.
I really wish that Excel had the capability of making
labels like MS Word has.
Hope you can help me.
Thanks,Deborah
 
Hi Deborah,

In your Access database choose File>Get External
Data>Import to import your Excel data. In the dialog that
appears select 'Microsoft Excel .xls' in the Files of Type
dropdown and locate the workbook that has your
information. Once the data is in Access you can create a
mailing labels report with the Labels Wizard.

hth

chas
 
Hi Deborah,

Excel can't do labels by itself, but you can do it by using Word to make
the labels with data from Excel.

Just start up the Word mailmerge wizard; tell it you want to create
labels, and when the time comes to specify the data source, just
navigate to your Excel workbook and select the worksheet with the names
and addresses on it.


I have a mailing list that I would like to convert to
Access. I'm following the directions from the assistance
center website but it won't bring up the actual data. I'm
attempting to make mailing labels.I doesn't take me to
the import spreadsheet wizard.
I really wish that Excel had the capability of making
labels like MS Word has.
Hope you can help me.
Thanks,Deborah
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top