hi everyone
i have a excel file and i want to have this file in access and use it
how can i make access file from this excel file?
thanks
hi everyone
i have a excel file and i want to have this file in access and use it
how can i make access file from this excel file?
thanks
Possibly each sheet (except for Total) would be a table.
I see a lot of data duplicated across sheets (such as name info) so will need a lookup table for this data then save primary key as foreign in related tables.
Have you studied introductory tutorial on relational db design?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi
Can you upload a copy of the Excel file with all text in English?