I need to convert an Excel file to Access.

K

Ken Snell [MVP]

That's a very broad request....

Could range from just importing data from EXCEL into ACCESS, to reproducing
formulas in ACCESS, to whatever.

Perhaps you could be a bit more specific?
 
J

John Vinson

I need help in converting an excel file to Access.
Click to expand...

Please explain. Excel is a spreadsheet; Access is a relational
database. An Excel Workbook is a very different object than a set of
related tables!

You can *import the data in a spreadsheet* into an Access table, using
File... Get External data... Import from the menu. Select Excel from
the "files of type" dropdown. However, the spreadsheets will come in
*as data*; Access tables do not support expressions in fields (you
would use Queries instead).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top