For importing data i issue this syntax
import from book1 database sale name importeddata type xl97 sheet sheet1
An OLE error return. I couldn't understand this error. When i import data from excel4 sheet it imported correctely.

But i want to import from excel97 and want to write a routine in command button so that user click button and data importe automatically.
Please Guide me.

Nafees