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$];