Exporting Tables to a Fixed Length text file

W

Wayne Bouwman

Using Access 2000 (no services packs) trying to export a table to fixed
length txt file. The Access Table is sorted in the sequence that i NEED the
text file sorted in, but after i perform the TransferText acExportFixed
funtion, the resulting text file is in a different sequnece then my source
table.

Can anybody tell me if they've run into an issue like this and if there is a
resolution to this problem in any of the service packs before i actually tell
my customer to upgrade to the latest service pack or upgrade to a newer
version of Access?

Thxs in Advance!
 
J

John Nurick

Hi Wayne,

Access tables don't have any inherent sequence. You need to create a
query that explicitly sorts the data into the order you want, and then
export the query to the fixed-width file.

On Fri, 12 Nov 2004 10:43:03 -0800, "Wayne Bouwman" <Wayne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Table to Text file including Fielnames 2
Export fixed width file from Access 2003 2
Export Table to fixed length txt file 1
Fixed Width - No delimiters - ASCII Text File 7
Exporting Fixed Width Text File 4
Importing Fixed Length File into Access 2007 1
Export table in to multipe text files 1
Bug fixed in Access 2003 re-introduced in Access 2007 4

Top