excel as database
Posted by nick on April 02, 2001 4:26 AM
is it possible to open an excel table as a database access table. or copy the cells over with moving anything
Posted by Michelle on April 02, 2001 7:27 AM
You can link the excel file from within Access:
Under Tables, click new, Link, then follow the wizard
OR
You can take the option under 'Data' menu in Excel to convert to MS Access. This will put a text box on your Excel file that can be easily deleted.
Hope this helps.
