	AllExperts > Experts
	Search

About Marty Landman
Expertise
Database installation, analysis & design and programming questions.

Experience
Have done application programming as well as some installation and administration mostly with MySQL for web servers and site development and also with IMS and DB2 on legacy systems in the past.

Education/Credentials
MS in computer science.

You are here: Experts > Industry > Data Management > Database Programming > ms access

Topic: Database Programming

Expert: Marty Landman
Date: 2/29/2008
Subject: ms access

Question
Hi,
I have a database from which I need to export data (a query)!
The data needs to be exported in a text format with fixed spacing between columns. I am using a the export specs, however the exported data does not come as I need it. Example: in between some columns I can't have any space and between some other columns I need to have 3 to 5 spaces and the numbers need to be right justified...
Any help will be greatly appreciated!
Thanks,
Neil

Answer
Neil,

I'm not familiar with MS Access' export options, however maybe this shareware product will be helpful

http://littlelink.webtrouble.com/?C5nu

Otherwise it may be that you'll need a little post-processor program written to format the exported data just the way you need it.

--
Marty Landman, Face 2 Interface Inc.
Drupal Development Blog: http://drupal.face2interface.com/
Free Database Search App: http://face2interface.com/Products/FormATable.shtml

Add to this Answer Ask a Question

About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.