Import data from a .xls file

[jeff1]

I need to import data from a .xls file (only the rows that contain data) and append the data to a table. I also need to give the user the ability to browse and select the file to import the data from.

Thanks to everyone for your help.

 

[judgehopkins]

To start your research, try looking at this thread:
thread707-610873

I know nothing about Excel but that thread looks like it points you in the right direction.

"The nice thing about being a celebrity is that when you bore people, they think it's their fault." - Henry Kissinger

 

[cas20002000]

Try Microsoft Knowledge Base Article - 115190

http://support.microsoft.com/default.aspx?scid=kb;en-us;115190

Function ImportXL5 ()
DoCmd.TransferSpreadsheet _
acImport,5,"TestTable","C:\T.XLS",True,"Sheet5!"
End Function