Hi! Everyone,:wave:
I want to write a app import .xls to SQL Server
How can I import .xls to SQL Server ?
Anyone have some demo.
Please help me.
Thank you so much.
Best regards,
Printable View
Hi! Everyone,:wave:
I want to write a app import .xls to SQL Server
How can I import .xls to SQL Server ?
Anyone have some demo.
Please help me.
Thank you so much.
Best regards,
Hi.
The easiest way probably would be to create a macro with VBA in the Excel file that creates a connection to the SQL server and then adds the information.
Don't think it would be to hard to do.
If you want me to help, feel free to contact me on MSN or ICQ.
Regards,
Michael