Search results for query: *

  1. S

    Import Text File into Access Database

    Thanks for your advice. I will give it a shot. If I have any other questions I will let you know.
  2. S

    Import Text File into Access Database

    Okay, i think i got a little off track. I got the import to work using the access automation. But for some reason it is only importing one record for each unique key and not importing anything else. I'm still trying to figure out why. You said it would be better to use ADO.NET. I've...
  3. S

    Import Text File into Access Database

    The only problem is the file I am importing into the Access database is not a CSV file. It is a text file that is delimited by either tab or quotes! Sorry for my ignorance on this. I am very new to this level of programming.
  4. S

    Import Text File into Access Database

    I'm Sorry the code in VB6 I'm using is: Access.Application.DoCmd.TransferText
  5. S

    Import Text File into Access Database

    Thanks for the reply's. To be honest, the code I am trying is code copied from a previous post to a similar problem. I have no idea if it should or could work. I know it is possible in VB6 using a statement similar to: App.Path.DoCmd.TransferText would System.IO.Streamreader be similar?
  7. S

    Import Text File into Access Database

    Here is what I am trying to do. Hopefully someone with more knowledge than me can help. I want to write a code that will open a text file on a local pc, and import that text file directly into an Access database. There will be several files to import and therefore several tables in...
Back
Top