473,467 Members | 1,573 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

VBA: Easy Way To Export Fixed Width Text File For A Table?

Hi Gang

I need to create text files from a bunch of tables. These text files
need to be fixed with files that match the table definition. In VBA is
there an easy way to get a list of tables in the database and then
create a fixed with text file for each containing all the data?

I know it's a lot but I thought I'd ask.

Andy

Nov 24 '05 #1
1 2622
Br
an***********@siemens.com wrote:
Hi Gang

I need to create text files from a bunch of tables. These text files
need to be fixed with files that match the table definition. In VBA
is there an easy way to get a list of tables in the database and then
create a fixed with text file for each containing all the data?

I know it's a lot but I thought I'd ask.

Andy


Lookup Docmd.TranferText in the help.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 24 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ted Theodoropoulos | last post by:
i posted an earlier thread about exporting data from a subform in an ..ADP to an .MDB file. i had only one gracious response but it wouldn't work in the given situation. so i thought i would...
5
by: Reggie | last post by:
Hi and TIA! I have a query that I want to save as a fixed-width text file. I can get the export to work using an export specification with one exception. This is a government message and they need...
1
by: ANDRESUK | last post by:
Everyone, I'm trying to export a table containing numeric fields with formats such as "00000000" which would return the value with some leading zeros. It works fine in the table as it is...
3
by: Daniel Wetzler | last post by:
Dear MSSQL- experts, I have a strange problem with SQLSERVER 2000. I tried to export a table of about 40000 lines into a text file using the Enterprise manager export assitant. I was astonished...
0
by: gelangov | last post by:
I want to export a table into a "fixed width" file using SQL 2005 import export wizard. This is the version I have: SQL Server 2005 - 9.00.2047.00 For some reason it joins all the rows...
1
by: gelangov | last post by:
I am sorry, I am posting this message again, since I did not get any reply. I want to export a table into a "fixed width" file using SQL 2005 import export wizard. This is the version I have:...
1
by: jpetrie | last post by:
We're using Access 2003, on XP systems. All users are on SP2. We've written a database that works fine in IT, but the end users are not able to run it. The process includes exporting a table to...
3
by: Wayne | last post by:
I'm trying to automate the export of a query to a text file using code. If I export the query manually I get the exact result that I want i.e. If I select the query then choose File/Export from...
0
by: Max | last post by:
Hi I am trying to export an Access table to a fixed-width text file. The table contains 2 memo fields of approx. 1000 characters each. I am using the 'Export text wizard' to export. In this...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.