Just downloaded VB Express with SQL Server Express....I want to import the current database, which is in Excel spreadsheet format to VB. Is this possible so I don't have to re-enter the data
Pam
How can I import data from Excel into VB Express?
Hot Topic
- A problem has been encountered while loading the setup components. Canceling setup.
- Creating Shortcuts For Applications/Files
- 3d games?
- No Debug?
- the code has some problem
- LPCWSTR doesn't work with reg commands
- Visual Basic 2005 Express Edition Database Explorer does not show updates to database.
- Registration Benefit Portal
- Visual Studio C++ Express 2005 builds send my monitor nuts
- Null for Rows?
VS Express Editions
- Problem with my VB program!
- Error when trying to create new app
- File Read/Saving Question.
- Web Install shows XML
- How to change disabled combo and datepicker background?
- Printing a form
- Forum dead??
- Visual Basic Express Resell
- Time - Increasing
- Serializing DataGridView (or DataSet) to disk file instead of using external database like SQL Server 2005.
How can I import data from Excel into VB Express?
TimMulholland
Jason,
I'm sorry to be so dense, but I'm not a programmer and I have limited experience.
I created my table and added the column names and types to the table and save it.
When I go to add the data, I do DATA, SHOW TABLE DATA and paste the excel data. But it only is copied to the first column. Help and forgive me for my stupidity!
Thank you.
Pam
CurtTampa
Are you saying that I have to copy the contents of each cell in the Excel spreadsheet one at a time Please expand on your answer....thank you very much!
Pam
Flavio Roberto
No problem Pam... Glad to be of assistance...
johncharle
Thank you! It worked through Access!
Pam
msheridan
I don't know why it didn't work. The only other thing I can think of is if you use MS Access first to create the table then paste the data from Excel to your MS Access table (I know this definately works) then import it into your SQL server.
I don't really use SQL that much, but it's worth a try!
neilchan
Pam,
You can select the entire range of your table in excel, Edit> Copy
Create a new table using Database Explorer in VB 2005 Express, Add your column names then Edit> Paste.
calloatti
Yes, this is possible.
Create your new table in Microsoft Visual Basic Express Edition Database Explorer, copy and paste the data from your Excel spreadsheet into your new table.