On Fri, 20 Oct 2006 05:05:01 -0700, Lilian - PD <Lilian -
Hi there...
How can I transfer an exiting Excel file (workbook) to Access? It seems like
easier to generate reports and look up the data by using Access.
Thanks for your help!
Lilian : )
You can use File... Get External Data... Import to import the *DATA*
in your workbooks into an Access table.
I emphasize the data part because Excel expressions will NOT be in the
table. An Access Table may *look* like a spreadsheet but it is
emphatically different. For one thing, your table will not and should
not - indeed *cannot* - contain any calculations; these should be done
in Queries or directly on forms or reports. In addition, it's a good
spreadsheet design to have many repeating columns (e.g. dates or date
ranges); this is good in spreadsheets but very bad in a normalized
table. You'll almost surely need to restructure much of your data!
I think it's a good move, but don't assume it will be trivial!
John W. Vinson[MVP]
