Hi
I have re-written this question with further information about my test data
please don't dismiss it as being previously answered because it wasn't
I am having trouble with the transfertext acexportdelim function.

I have an access 2000 database that in code runs serveral csv export routines.
One of the routines has dates in it.
In the underpinning tables and queries the date has been formatted to
dd/mm/yy but every time i run the exports the dates always come out as

I have a code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Test
Import Specification", mytxtbox, True, "Heffalump!"
This code takes excel spreadsheet, tab named Heffalump and puts ALL the

exporting from fields in a table to a txt file
using transfertext action in a macro
when i open the text file the fields are in quotes  
can i transfer without quotes appearing?

I try to use the MS-Office Plus 2007. I would like to save as my works to
other file formate like dBase or dbf files, but I can't do it. Becuase I want
to link it to work it other program for analizing it. Does everyone can
solved it for me.

we have recently created a new mdb file to use as our master database.
i need to import data from our old database, our email listserv, and
numerous smaller excel and access lists.  much of the information,
especially in our master db and online list is overlapping.

--Cross-posted from Setupconfig list---
I have a program that works w/ Excel using the Jet 3.5 engine. I need to
install the Excel data access options from the Access 2002 setup. BUT, I
can't find them in the add/remove options when I attempt to add the item.

Hi, I am trying to import text strings into an access table. Some of the text
contains characters (eg the German ö, letter o with diaeresis), when I
inspect the loaded string in Access has converted it to the division
character double bar with dot above and below like  ÷.

I am looking for a way to export records from Access tables or queries to
Excel where I can specify one or more tabs in one spreadsheet.  For example,
when I export sales records, I'd like to specify a tab for each product line
but keep the output in one Excel spreadsheet.

i am using the transferspreadsheet:
DoCmd.TransferSpreadsheet transfertype:=acImport, _
           tableName:=tableName, _
           fileName:=fileName, Hasfieldnames:=True, _

Here's the challenge:
I have a request to be able to import a Standard Interchange Format
(.sif) file into an Access database on demand. The file layout is
standard ASCII text and is fairly simple, but I can't seem to wrap my

I am trying to import a data set into MS Access from a text data file.  There
are 109 and columns that need to be in the structure.  It is a fixed width
flat file.  I have already a saved specifications for 106 columns for a
similar flat text file which works fine, adding 3 more ...

I tried using the codes provided below and I got the form working
http://support.microsoft.com/kb/209963
but the problem is
1. The Appointment date comes out as 07/23/2003 even if put in tomorrow's

I have imported an Access tables into Outllok and want to display in
Detailed Address Card View.  I want all the addresses to be displayed
by the Company name and niot the contact name.   I know I can do this
individually and choosing the Company Name in the file as box.  Is

I have a form that exports a table with the following command:
docmd.transfertext asExportFixed, "tbl_el Export Specification",
"tbl_el", "C:\tbl_el.txt"
That works great on my test system.  When I copy the database and send