Recent content by jtammyg713

if I use this code below it works but using listboxes...I need to be able to type the name of the server instead of getting it from a listbox. Imports System Imports System.IO Imports System.Collections Imports System.Data Imports System.Data.OleDb Imports System.Data.SqlClient Imports...

Hi Riverguy! thank you for your reply! I'm sorry but I am new to VB....how do I do that? Thanks! Regards, Tammy

Hi! Once again I have hit a brick wall here. I have a combobox in which the user types the server name and then clicks on button 'CONNECT' to populate the next combobox which contains all the databases in that server. Then after the user selects a database, I have another button that...

Sorwen, You are a genius!!!!!! That worked!!!!! Now I have to be able to create the table on the fly, before bulkcopying to it!!!!! Thanks a lot!!!!!!!!!!!!!!!!!! :-) You made my day!!! Tammy

sorwen, This is the solution I came up with...but I cannot get it to work. 'Declare Variables - Edit these based on your particular situation Dim sSQLTable As String = "client_lehman_MBS.dbo.TEST_TAMMY" Dim sExcelFileName As String = "C:\casey.xls" Dim sWorkbook...

I found this online but I am getting stuck at the with cn part in which i get an error : value of type 'system.data.sqlclient.sqlconnection' cannot be converted to 'string' Below is the code I am trying to use: Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As...

Hi! I have a datagridview with hidden columns. I want to create a table in a sql server programmatically and then only export the visible columns form the datagridview to it. How can I achieve this? Thanks a lot for the help to this newbie!!! Tammy