Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tecknowledge1164
Starting Member
25 Posts |
 Posted - 2007-04-17 : 18:43:54
|
| I need to convert some data from a SQL 2000 database and place it in a SQLExpress 2005 database using Visual Basic 2005. I have a program that selects the records out of the existing database, puts them in a datareader, assigns values to the variables and inserts them into the new database. My situation is that in the old database there are two fields that have multiple values separated by commas that need to be broken out into several records with a single value in those fields. There are anywhere from two up to six values in these fields. I am looking at using the split function in visual basic to accomplish this, but I am not sure exactly how to implement this syntax-wise into my sub. I'm not exactly sure how the array that is created by the function facilitates getting a whole new row for the table as it goes through the records. Any ideas or pointers would be greatly appreciated. Thanks. |
|
|
tecknowledge1164
Starting Member
25 Posts |
Posted - 2007-04-18 : 16:14:53
|
| Never mind, I got it to work. Thanks anyway. |
 |
|
|
|
|
|
Converting records using split function