Search results for query: *

  1. S

    console app to back up database - problems with SQLDMO

    Hi John, I did notice the SMO reference and tried to add that as a reference as well but it doesnt show up even when i search for it in the object browser? Do you think its because I am using the express editions of vb.net and sql server? Thanks Sally
  2. S

    console app to back up database - problems with SQLDMO

    Hi people, I have created a console app which is supposed to backup a database. I wanted to use SQLDMO as alot of the examples are in this but get an error when running my code like below: COMException was unhandled Retrieving the COM class factory for component with CLSID...
  3. S

    Reading in a csv file

    I am such a doofus! Basically I am a wally. I had the datatypes to accept only 10 chars. When the error was trying to insert into the database it was failing because it was 11 chars long!
  4. S

    Reading in a csv file

    Here is the part of my code which gets the data from the csv file: Dim objSRFile As StreamReader Dim strInput, arrStrInput() As String Dim intCurrPos As Integer Dim ref, greeted, catalogue, fitProduct, itemsNotOffered, shopAgain, recommend, age, lastTiles, hearOfUs...
  5. S

    Reading in a csv file

    Hi everyone, I have a problem when I read in a csv file, split the string by delimeters and put into a sql database. The code works fine apart from when there is a # symbol in the csv file. The csv file contains data from scanning questionnare forms and gives an error (error #3100) when the...
  6. S

    Updating database table from | delimeted text file

    i agree errm yes it is a bit hard to read, I will make my posts more readable in the future!
  7. S

    Updating database table from | delimeted text file

    Ok have worked this out now first I replaced the | with a , and dropped the table: Module Module1 Sub Main() Dim fso, inputFile, outputFile Dim str As String fso = CreateObject("Scripting.FileSystemObject") '1 means for reading inputFile =...
  8. S

    Updating database table from | delimeted text file

    Hi everyone, I have an access table and I need to be able to update the table with data from a | delimeted text file. The textfile is like below: At the moment I have some vb.net code which puts the data into a table (creates a new table) I actually need it to update the table (rather than...
  9. S

    Querying a table in an ms access database

    Hi everyone, Basically I have a vb.net form with a combobox, 2 textboxes a button and a ListBox. I have an access database with sales details on it i need to grab the details of the combobox and textboxes and use them to do a search on the database table then displaying the results into a...
  10. S

    creating an sql search from 2 comboboxes

    Hi does anyone know how to creating an sql search from 2 comboboxes in vb.net. I have an access database with one table and need to be able to do a search depending on what the user selects in the 2 comboboxes then display the results in a listbox. Has anyone got any similar code that would...
Back
Top