Access 2002 Export question - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
Thread Tools Display Modes
Old 07-29-2005, 10:50 AM   #1 (permalink)
Super Techie
Join Date: Mar 2005
Posts: 499
Question Access 2002 Export question

Hi folks, hopefully someone out there can hep me with this:

We maintain a database here at work that is exported to a text-delimited file every month and sent to our production company.
They require the text to be identified with text qualifiers ("), which will exclude any numerical values. Our problem is that our ID numbers for this product begin with a "C" - C0001, C0002, etc.
Because of this, when I export the file, Access understands the ID numbers to be text and gives it the quotes as text qualifiers.

Well, the production company can't process the file with the ID numbers having text qualifiers so I have to remove them manually before I send the file to them. When the database had 150 entries.. that wasn't a big deal.. but it's approaching 500 entries now and it's taking serious time.

I couldn't figure out how to exclude the ID field from having text qualifiers when exporting the file... does anyone know a work-around I can use to avoid this??

<a href=\"\"><img src=\"\" border=\"0\"></a>
\"All over the place, from the popular culture to the propaganda system, there is constant pressure to make people feel that they are helpless, that the only role they can have is to ratify decisions and to consume.\" -Noam Chomsky
smileygladhands is offline  
Closed Thread

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
Trackbacks are On
Pingbacks are On
Refbacks are Off

Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 07:42 AM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2019, vBulletin Solutions, Inc.