Sad Der
accessd666 at yahoo.com
Tue Mar 1 08:47:25 CST 2005
Terri, my mistake...I wasn't clear with my question. What I meant was: I need to link a csv file in Access 2000 USING VBA does anybody know how to do this? Background info: I need to run 68 reports. They all have 1 or more csv as input source. At this point we need to manually link them as described by terri. This is very time consuming. I want to create something so that the user selects a report and then automagically the following things happen: - the required csv files are linked (or imported) - the required queries are started - the created table (via the queries) is exported to Excel. That's all. Sander --- Terri Jarus <jarus at amerinet-gpo.com> wrote: > You do that exactly as you would link any other > file/table. Select File > - Get External Data - Link Tables; select Text Files > from Files of Type > dropdown and select the appropriate file. > > That's all there is to it. > > Terri Jarus > Vice President, Contract Services > jarus at amerinet-gpo.com > 314-542-1902 > > >>> accessd666 at yahoo.com 3/1/2005 12:52:34 AM >>> > > Hi group, > > I need to link a csv file in Access 2000. > > Does anybody know how I can achieve this? > > Thnx > > Sander > > > > __________________________________ > Do you Yahoo!? > Yahoo! Sports - Sign up for Fantasy Baseball. > http://baseball.fantasysports.yahoo.com/ > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > --------------------------------------------------------------------------- > This email and any files transmitted with it are > confidential and > intended solely for the use of the individuals or > entities to whom they > are addressed. If you have received this email in > error please return > it to the sender, and erase any copies thereof. > Copyright 2005 Amerinet 1nc. > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > __________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail