home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 10,779 of 10,840   
   JP to All   
   Import to/Export From Existing Access 20   
   16 Jun 09 13:15:47   
   
   From: jprobb@seniortrans.com   
      
   Hi:   
      
   I'm trying to import a *.csv file into an existing Access 2000 table using   
   VB 6.0.  The *.csv file can have between 40 and 48 fields, and the table in   
   Access 2000 has a constant 48 fields.  After I manipulate the data, it must   
   be exported into a *.csv file and uploaded to software on the Internet.   
      
   Is there an example somewhere that will show how this can be done using VB   
   6.0?  I've looked at the VisData example in the Samples, but it looks for a   
   *.txt file.  I've changed the extension on the file from *.csv to *.txt, but   
   it says that it cannot open it because it is in used by someone else, or I   
   don't have permission to open it.  Then when I have been able to get a *.txt   
   file open, it makes a new table... I can't have it going into a "new" table.   
      
   Any advice or assistance would be deeply appreciated.   
      
   Joe-Paul   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca