convert Excel data to Access
Does anyone know how to convert excel spread sheet into
Access? the excel file have mulitple spread sheet. I am using the
marco to pick up the data from the sheet1 then output to sheet2, and
then calcurate the result to output to sheet3. How can I import those
data to access? I tried to use import data from external data in
Access, but it doesn't work. Any suggestions? Thanks
|