Does anyone know of a way to import a .csv file into an Access 2000 table (actually a SQL table using Access as a front end) the same way the TransferSpreadSheet command imports a .xls file? Would like to do this via VBA code, not via the import file method (i.e. File|Get External Data|Import..) from the menu bar.
Thanks for any assistance you can offer.
Thanks for any assistance you can offer.