[AccessD] Exporting Using Code

Thanks,
I tried reversing the process, i.e bringing the text file into the table but said I can't define field more than once, I think it's because there are no field names in the text file.  Is there a way of saying there are no field names in the text file ?
Paul 

Message date : Aug 06 2004, 02:33 PM
>From : "Gustav Brock" 
To : "Access Developers discussion and problem solving" 
Copy to : 
Subject : Re: [AccessD] Exporting Using Code
Hi paul

The general syntax is like:

SELECT
*
INTO
[Text;Database=C:\Windows\Temp].[TestDate.txt]
FROM
tblExportFrom;

/gustav


> I have the following code to export a query into an excel sheet:
> strSQL = "SELECT * INTO " & _
> "[Excel 8.0; Database=C:\Email\ProgrammeSummary.xls].” & _
> “[ProgrammeSummary] " & _
> "FROM qryProgrammeSummary "
>
> Does anyone know if I can use the same method to export to a text
> file, if so could someone show me the syntax to it, cause I have
> been playing around with this for the last hour, and can’t seem to
> do it.

> Thanks in advance for any help.

> Paul Hartland

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm