I need to convert an Excel file to Access.

[Guest]

I need help in converting an excel file to Access.

 

[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?

 

[John Vinson]

I need help in converting an excel file to Access.

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

 

[Joseph Meehan]

I need help in converting an excel file to Access.

Well based on what you asked, I can say all you need to do is to use the
import feature in Access.