Microsoft Office Forums


Reply
Thread Tools Display Modes

Text Only - Fixed Width Files

 
 
Novice2000
Guest
Posts: n/a

 
      04-23-2009, 11:33 PM
I have built a query and need to be able to export it as a Text Only - Fixed
Width file not comma delimited or csv files.

I can't remember how to do this, but set the query up last summer and it was
working. Can anyone help me remember how to do this?
 
Reply With Quote
 
 
 
 
Mark Andrews
Guest
Posts: n/a

 
      04-24-2009, 12:26 AM
You use an export specification. If you highliught a table and choose
file/export, pick text format and the wizard starts up and asks if you want
a delimited or fixed width file. From there you can access export
specification if you want to save the settings for later, or use it in code
etc...

HTH,
Mark
RPT Software
http://www.rptsoftware.com

"Novice2000" <(E-Mail Removed)> wrote in message
news:07D4DDBC-90BA-4B18-8E44-(E-Mail Removed)...
>I have built a query and need to be able to export it as a Text Only -
>Fixed
> Width file not comma delimited or csv files.
>
> I can't remember how to do this, but set the query up last summer and it
> was
> working. Can anyone help me remember how to do this?



 
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting Fixed Width Text File Jen Scott Access Newsgroup 4 04-06-2009 03:54 PM
Error importing dates from fixed width txt files Lisa Access Newsgroup 0 02-21-2008 09:19 PM
Text to Column with fixed width kathy.aubin@gmail.com Access Newsgroup 2 11-17-2007 03:33 AM
Importing Fixed Width Text Duane Access Newsgroup 2 04-28-2007 09:34 PM
Creating fixed width text files in Access 2003 Byzantine Access Newsgroup 7 12-13-2004 09:09 AM



All times are GMT. The time now is 02:17 PM.