Okay, I created a reformat method that takes care of the input file. It was very easy.
However, does anyone know why the Rows Property of the SQL-DMO Table object does not refresh the property values. I was trying to get a before and after count with the number of rows imported. The Rows...
Hi Chip,
We are trying to minimize any modification to our application that I designated as Server X (location of our application).
The application will give me the file as is and I have to attempt to import as is. Unfortunately, for us and our customer, we encountered "Murphy" way too many...
Hi Kevin,
Yes thank you very much for your prompt response.
I am very much considering this option. I have been doing my own separate research on the internet on date formating via SQL-DMO objects such as the BulkCopy and ImportData objects that I am using and it seems there is no way to...
I have a VB6 application that utilizes SQL-DMO to import a file into a table (ImportData Method is used). However, I receive the following error "Invalid date format @#" when I execute the program.
The issue is, I have a Server X with regional setting for date as dd/mm/yyyy and the Database...
I have a VB6 application that utilizes SQL-DMO to import a file into a table (ImportData Method is used). However, I receive the following error "Invalid date format @#" when I execute the program.
The issue is, I have a Server X with regional setting for date as dd/mm/yyyy and the Database...
I am having a problem with some Word 2000 Documents being checked into Visual SourceSafe 6.0 where these documents become corrupted after check in.
I would perform the Add function to project and checkin the document. However, when I perform a checkout and try to open the document then I would...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.