Hi Fred,
Excel is a spreadsheet program and Access is a relational database
management system. The concepts involved and the facilities offered by
each are so different that there's no one way of converting from one to
the other.
It's normally possible to import the data from your Excel worksheet(s)
into Access tables (create a new database in Access and then use
File|Get External Data Import). Sometimes, it works better if you export
the data from Excel as a textfile (CSV) and then import that into the
Access database.
However, any searching, grouping, data entry forms, macros etc. in the
Excel database will have to be re-created in Access (typically with
queries, reports, forms and VBA code). In addition, it's usually
desirable and sometimes necessary to restructure the data after import
in order to take advantage of Access's features.
How can I converse an excel database into an access
database?
For information I have Office 2000
Thanks
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
