Charlotte Foust
cfoust at infostatsystems.com
Tue Jun 10 11:26:15 CDT 2003
If by Db4 you mean dBase IV, then try the TransferDatabase command instead. dBase IV is one of the formats supported. Charlotte Foust -----Original Message----- From: Scott Gage [mailto:scotttgage at yahoo.com] Sent: Tuesday, June 10, 2003 8:17 AM To: accessd at databaseadvisors.com Subject: [AccessD] Export a Db4 file I need to script the export of a file in the Db4 format. Below I am using "TransferText" to send a txt or ascii file and it works great however the "OutputTo" will not allow me to create the Db4 file that I need. The Excel file works but is not right. Any suggestions? DoCmd.TransferText acExportFixed, "Send", "Send", Pathname DoCmd.OutputTo acOutputTable, "SendMI", acFormatXLS, Pathname8 BTW these exported files end up as attachments to e-mail messages ===== -------------------- Scott T. Gage Scott.gage at promedica.org 419.291-7177 __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com