 |
| ASP.NET 4 General Discussion For ASP.NET 4 discussions not relating to a specific Wrox book |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the ASP.NET 4 General Discussion section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
September 9th, 2011, 01:06 AM
|
|
Authorized User
|
|
Join Date: Aug 2011
Posts: 32
Thanks: 2
Thanked 0 Times in 0 Posts
|
|
importing or converting an excel data base
I have a database in excel, and I would like to import it or convert it in order to retreive this data to my page. Since the database is too long, I don't want to re-type everything again. How can I convert it or import it to VWD 2010?
|
|
September 9th, 2011, 03:19 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Hi there,
If you have a full version of SQL Server (not Express) you can use Import / Export wizard to import data into a SQL Server (or other database).
Cheers,
Imar
|
|
September 9th, 2011, 05:01 AM
|
|
Registered User
|
|
Join Date: Aug 2011
Posts: 13
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
Quote:
Originally Posted by Imar
If you have a full version of SQL Server (not Express) you can use Import / Export wizard to import data into a SQL Server (or other database).
|
If you install Microsoft SQL Server 2008 R2 Management Studio Express, you get the Import/Export Wizard. Once Management Studio is installed you can run the Wizard from the All Programs menu.
The download is currently at http://www.microsoft.com/download/en....aspx?id=22985
|
|
The Following User Says Thank You to mmmason For This Useful Post:
|
Imar (September 9th, 2011)
|
|
September 9th, 2011, 06:17 AM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Ah, didn't realize it was also part of the Express edition. Thanks for the update.
Cheers,
Imar
|
|
September 10th, 2011, 10:21 PM
|
|
Authorized User
|
|
Join Date: Aug 2011
Posts: 32
Thanks: 2
Thanked 0 Times in 0 Posts
|
|
Thanks!. I see you have two options there:
SQLManagementStudio_x64_ENU.exe and
SQLManagementStudio_x86_ENU.exe
What's the difference? I want to know which one to download
|
|
September 11th, 2011, 04:07 AM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
The x64 file is for 64 bit versions of Windows and the x86 version is for 32 bit versions.
Cheers,
Imar
|
|
September 19th, 2011, 06:15 PM
|
|
Authorized User
|
|
Join Date: May 2011
Posts: 19
Thanks: 3
Thanked 0 Times in 0 Posts
|
|
Use x32 for Excel
Having been there myself, you will want to use the x32 version of the import/export utility. Office (I think) is considered an x32 product so it has Excel as a predefined option for the import.
Last edited by DragonLEG; September 19th, 2011 at 06:16 PM..
Reason: spelling
|
|
September 20th, 2011, 03:18 PM
|
|
Registered User
|
|
Join Date: Aug 2011
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
|
|
I've been struggling with the same issue. Running Windows 7 and the Express Edition of SQL Management Studio has known 'compatibility issues.' Did you manage to install it?
|
|
September 20th, 2011, 03:33 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Which version of SQL Server are you talking about? If I am not mistaken, the message refers to an unpatched SQL Server of 2005 / 2008. Installing the latest service pack should solve that issue.
I have SQL Server 2005, 2008, and 2008 R2 all running side by side on Windows 7.
Imar
|
|
September 20th, 2011, 03:47 PM
|
|
Registered User
|
|
Join Date: Aug 2011
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
|
|
I am running the express version of MS SQL. Might be a service pack update issue. The express editions do require a bit more work.
Thanks for your, as always, prompt reply.
Best,
Jonathan
|
|
|
button below this post to show your appreciation!
