saving to a csv file
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
- From: <arch>
- Date: Wed, 11 May 2005 21:15:39 +0800
Hi. I'm using Access 2000 and I'm having trouble trying to create some vba
code that will allow me to save the data in a query to a csv file (comma
separated text). I used the acCmdImport command to import the data file
originally. However, I don't know how to export it (preferably with a gui
to allow the user to enter a filename to save to). Please provide sample
code.
.
Relevant Pages
- Re: Make VBA open a browser window
... I have this code in VBA that calls a query table from a certain csv file. ... .AllowMultiSelect = False ...
(microsoft.public.excel.programming) - Re: Make VBA open a browser window
... I have this code in VBA that calls a query table from a certain csv file. ... .AllowMultiSelect = False ...
(microsoft.public.excel.programming) - Re: Make VBA open a browser window
... I have this code in VBA that calls a query table from a certain csv file. ... .AllowMultiSelect = False ...
(microsoft.public.excel.programming) - Querying a CSV file from Excel
... I have a CSV file with 4 columns 100,000 rows. ... to import a portion of the data into an excel spreadsheet. ... Is it possible to query data in a CSV file (i.e. text ... I want to be able to enter a date in my VBA ...
(microsoft.public.excel.programming) - RE: Link CSV file created query append query to append data
... numerically to come up with my run order in numeric sequence. ... can't accomplish this with the make table query. ... > to the csv file before you import it. ... >> not have 2 crucial fields that I need to be able to sort with and control the ...
(microsoft.public.access.queries) |
|
