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