Im currently working at a job attachment at CTO and the supervisor just came up to me saying she wants this in under 2 hours.
So is there anyone out there that can help me with code to import xls files into access? i know access has a built in function for it but what she wants done is to make a switchboard with a command button that:
1. imports a selected xls file
2. appends the file to the main table
3. ensures the field names are the same as the main table
thnx guys i wuld really appreciate this help...sorry bout the post before i cant seem to delete it
I would be wary about importing excel files, I have done this in VB using the excel object library and it had serious problems if there were more than 32,767 rows (which is an integer if I am not mistaken).
Common practise is to save the Excel file as a comma delimited file and then import the comma delimited file.
If you still really need to import using excel, then you need to research:
Microsft Excel 8.0 Object Library .DLL
You can make a reference to it in Tools/References (you need to be in a code module first).