Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-18-2006, 01:12 AM   #1
Poppy
Registered User
 
Join Date: Feb 2005
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Poppy is on a distinguished road
Export query with currency removed into comma delimited file

Hi

I know that it is possible to export a query into a comma delimited file from Access, however, my problem is that I have currencies in my table. I selected the field that is a currency in the query and changed it to a general number. I then exported it into a csv file, but the currency symbols are still showing. I also tried exporting the query results using a macro, but then I have these long dashes and heading in the file. There were also | seperating the fields in the file. How do I fix this?

I just want to be able to export the query result without the currency symbol into a comma delimited file.

Thanks for all your help

Kind Regards

Poppy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Export query results to text kevindmorgan Queries 0 03-07-2006 11:16 AM
Importing Pipe Delimited File Problem Canadian_topher General 8 07-22-2004 10:10 AM
Count query with comma delimited string betheball Queries 3 11-11-2003 06:35 PM
Export Parameter Query to Text Brian100x Queries 2 05-31-2002 12:57 PM
exporting a query as a text file through VBA Knobbie Queries 5 12-17-2001 06:29 PM




All times are GMT -8. The time now is 02:08 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World