Make an Access data base from Excel spreadsheet

M

mike

I would like to create an Access data base from an Excel spreadsheet with
multiple columns. I do not have acess to to MS Access Report option on the
Data menu.

thanks
 
R

Rick B

Not sure what you are talking about.

To create a database from a s\preadsheet, you would open acccess and create
a new table, then import the data from Excel.

Rick B
 
M

mike

Joseph
When I try to import file from Excel, I call up Excel but only the
folders
are listed in Excel, opening the folders finds that they are empty.
Mike
 
M

mike

Rick
When I try to import the Exel table, my Excel folders are listed only.
When I try to open the Excel folders, they are empty.
Mike
 
J

Jackie L

I am not sure why you would not be able to import a sheet but you can try
saving your sheets as .csv files and then importing into Access. Sometimes
Access assumes it knows your Excel file. Importing text files allows you to
have more control over the import and the field structure.

Hope this helps.
 
Top