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!
-
Congratulations dencom 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: *
- Users: Positivethinking
- Content: Threads
- Order by date
-
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...- Positivethinking
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
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...- Positivethinking
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
-
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...- Positivethinking
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
