I am using :
'SELECT UserId, LastName,FirstName FROM [Sheet1$]')
SELECT top 100 [User_Id], Last_Name, First_Name FROM dbo.Users
I realize that the text.xls must exist with the column names beforehand. However, I need to generate an excel file that has a different name that contains the data exported and empty the test.xls so that it will be able to be ready to receive data when a new request comes in with different parameters.
How do I do this?