G
Guest
Hi, I am very new to access and am in need of a bit of help. I am currently
working on an inventory system for our computers, and have all the data
entered into Excel. I have imported the spreadsheet into Access, but I would
like to create individual tables for the different PC types we have i.e. 1
table for all PII 1 table for all PIII etc. Is there a way I can get Access
to pull this data from my spreadsheet or the new database I created? I would
like only the fields with a value to be imported into the new table but onto
a seperate line in the table. Is this possible or do I need to re-enter all
my data?
working on an inventory system for our computers, and have all the data
entered into Excel. I have imported the spreadsheet into Access, but I would
like to create individual tables for the different PC types we have i.e. 1
table for all PII 1 table for all PIII etc. Is there a way I can get Access
to pull this data from my spreadsheet or the new database I created? I would
like only the fields with a value to be imported into the new table but onto
a seperate line in the table. Is this possible or do I need to re-enter all
my data?