1. Link to an Excel file and create a make table query.
2. Import from the Access 'File' menu.
3. Programmatically siphon data from the spreadsheet.
4. Import Excel data from the Clipboard
5. Other?
I'd like to build a database(relationnal) so I can make forms ,reports...
The spreadsheet is for a computer inventory.
I want to make forms to allow technicians to enter informations anywhere in the building.
A kind of realtime inventory.
I think that I'll have to build tables...?
thanks for hints!!
Make sure that you explicitly set the data types of all columns in Excel and I suggest naming the ranges that you want to import. To make a relational db you'll need to insert lookup fields to replace the existing flat file structure. Use the import command when in the "tables" section and follow the wizard prompts. Think about your datatypes and make sure that existing data is consistent with column datatype or you'll have irritating import problems. Also, your comments indicate that you need to spend some time in the woodshed bro (or you'll be wishing you still had spreadsheets).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.