upload excel file into sql server

[vic pahilan]

hi,
pls need help. I need to upload excel field to sql server field. the
user will choose excel file then i will show the fields inside that
excel file then copy it into sql server field. I already done the rest
but I dont know how to start coding with the command to upload. i use
the listview control for excel same with for sql server to display their
fields.

hope u can help. tnx n advance


*** Sent via Developersdex http://www.developersdex.com ***

[Larry Linson]

"vic pahilan" <ma******************@yahoo.com> wrote in message
news:tw****************@news.uswest.net...

hi,
pls need help. I need to upload excel field to sql server field. the
user will choose excel file then i will show the fields inside that
excel file then copy it into sql server field. I already done the rest
but I dont know how to start coding with the command to upload. i use
the listview control for excel same with for sql server to display their
fields.

hope u can help. tnx n advance

I don't see where Access is mentioned in your description. Perhaps you would
have a better chance at getting the answer you need if (1) you described how
Access is involved or (2) you asked the question in either an Excel
spreadsheet or an SQL Server newsgroup. This one is for Q&A about Microsoft
Access database software.

Larry Linson
Microsoft Access MVP