Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Positivethinking

    table errors when using TransferText to import a csv

    Hello everyone I am dealing with something apparently simple. Hopefully it is.I'm using ms access 2003 I am trying to import a csv file with the statement below: DoCmd.TransferText acImportDelim, , "myacctable", _ Application.CurrentProject.Path & "\myfile.csv", 1 but i am getting a...
  2. Positivethinking

    Compound Query

    Hello everyone, I need to create a query(ies) that allow to display all Subjects and Tubes with all the Analytes, notice that TABLE1 has Analytes1,2,3 and TABLE2 has Analytes4,5. Subj 1A has all 5 Analytes, a Subject could be in table 1 but not in table 2 or viceversa, or could be in both. The...
  3. Positivethinking

    open a csv file

    Hi all I need to open a csv file using vba and just rename the columns for a file that holds around 300 columns. I know that msaccess can handle only 255 columns. The questions is "does anyone know if handling 300 columns can be done in access without opening the csv file in a table just...

Part and Inventory Search

Back
Top