Question: how to import data from ms excel to ms access through vb6?
Answer: INSERT INTO MyDBTable ( ProductID, EAN, Description ) SELECT [ProdID], [EAN-Code], [ProdDescription] FROM [EXCEL 8.0;Database=" & CommonDialog1. FileName & ";HDR=YES]. [Sheet1$];