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
- How to print receipt in a picture box?
- Programming Languages
- Help please, with Hexadecimal and calculations
- SQL Database Connection not open?
- Debugger & Forms Designer in Beta 2 fails
- clocks and Excel, or ?
- I may have found a way (Excel to Form Controls) but one problem...
- Catching multiple buttons in one function
- I need to count by ascii characters. Seems tricky!
- My VB
VS Express Editions
- Visual Basic 6.0 -> Visual Basic 2005 Express
- Newbie Trying to get specific data from an sse database
- Connecting to a remote registry in VB 2005 Express
- Using the serial port component in the Visual Basic 2005 toolbox.
- Bug In VB Express If Statement?
- (newbie) How to refresh text box contents
- how can .net framework 2.0 replace 1.1?
- Installation Error in Visual Basic Expression Edition Plz Help
- VB.Net Express Edition will support to add new record to database?
- How to read and write a text file without screwing up the encoding
How can I import data from Excel into VB Express?
Mohamed Shifaz
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
Balmer
No problem Pam... Glad to be of assistance...
DebODiver
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!
JaYZhiE
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.
Krishnan -- MSFT
Thank you! It worked through Access!
Pam
MurrayBrown
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.
MrLister
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