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-10-03 : 12:11:45
|
| I am writing a data conversion program in vb.NET 2005 that reads data from delimited text files and inserts it into a SQLExpress database. In most cases it looks at one file using a DataReader to gather the variables and insert them. There is one Sub in the program that needs to join data in two of the text files and match it up with info in the destination database before it performs an insert. I don't seem to be able to directly perform this join on the two text files, even though there is a common field designated. I suspect I will need to use a temporary table or some other data object in Visual Basic to be able to work with the data in this way. If anyone could provide some pointers on how best to go about that I would appreciate it. Thanks in advance. |
|
|
tecknowledge1164
Starting Member
25 Posts |
Posted - 2007-10-05 : 14:36:49
|
| Never mind, I got it to work. I just needed to find one value that I could use on the destination side to narrow the search. |
 |
|
|
|
|
|
Data conversion