import Excel file to SQL 2005 database

I have an excel file that I would like to import to my SQL 2005 database. I know how to do this on my local machine using a Linked Server. However, with shared hosting, I don't have the permissions to do that. Has anyone else come up with a solution for importing your data to your SQL server? Thanks for any ideas you can offer.

 

I'm using SQL Server Management Studio Express CTP and I don't think that is available with that version. I have Visual Studio 2005 Standard and I don't think the Import/Export wizard comes with that either. If it does, I haven't found it. I did find some software that does Excel Import/Export for MS SQL at this link: http://www.softpedia.com/progDownload/Excel-MS-SQL-Server-Import-Export-Convert-Software-Download-43477.html It is only about $30 and the trial version I downloaded worked.

 

I just looked to see how much the full version of SQL Server 2005 (that has the import/export wizard) was and the developer version is around $42 at Amazon.com. I may just get that instead of register that other software, even though it worked for what I needed. Thanks for your reply.

 

Hi.
I am beating my head against a brick wall here, trying to figure out how to import and excel document in SQL 2008. The best way I can see is to convert the xls sheet to a csv and use the csv import in the mylittleadmin interface. Is there a better way? I have VS 2008 on my local PC.

 

See the attached. Perhaps I'm missing the point?

 

Bugger! Thanks for the reply. I could not find it for looking. Of course I came back to this page AFTER I had imported all the excel sheets by way of converting them to csv's.
I shall keep the pic so I remember next time!
Thanks again

 

No problem - I'm very familiar with the feeling I'm going blind looking for a solution. It happens to me most days.