I've just been assigned a task of getting all our employees on a form so we can individually print out profiles. I have all the information needed on three separate excel spreadsheets. Type of data: ssn, sal amt, location, start date, title.. approx 20 fields in all. Could someone help me with this project? Thanks!
HR Form - 3000+ employees
- Thread starter DAPPLE
- Start date
I don't know how much experience you have with Access, but basically, these are the steps you must take:
a) Run Access
b) Create a blank database
c) Get down to your database window
d) Import your tables into your database
To import your tables, go to:
- File
- Get external data
- Select your excel spreadsheet from the window that opens up.
- Read carefully and follow the import wizard's prompts.
If you do everything correctly, your new table will be created in the database in no time at all.
Good luck.
edtab
a) Run Access
b) Create a blank database
c) Get down to your database window
d) Import your tables into your database
To import your tables, go to:
- File
- Get external data
- Select your excel spreadsheet from the window that opens up.
- Read carefully and follow the import wizard's prompts.
If you do everything correctly, your new table will be created in the database in no time at all.
Good luck.
edtab
Oldsoftboss
AWF VIP
- Local time
- Tomorrow, 03:38
- Joined
- Oct 28, 2001
- Messages
- 2,499
You can open your new database, open your excel spreadsheet and select all the excel data then just drag and drop it into access. You should be asked if the first row of data contains the column name and presto, done !!
