Solved

How to export a blank column from an Access db

Posted on 2009-04-08
4
191 Views
Last Modified: 2013-11-27
I am trying to export a .csv file from an Access database using a simple query.
I have the basic mechanism working, but I need to create the .csv files with 2 blank columns.  It is here that I have drawn a blank.
The Access query defines the format of the .csv file, but I can't set up a blank (or dummy) column in the query.

Has anyone any ideas?

Best regards

Richard Tomalin
0
Comment
Question by:rltomalin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 24095915
you can try this in your query

"" as  blankcol1, "" as  blankcol2

in amongst your other fields you have selected
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 24095962
If u use query design to create your query, add two new fields like this

BlankCol1: ""
BlankCol2: ""

0
 

Author Closing Comment

by:rltomalin
ID: 31567973
That looks like it.  I knew it would be simple (but so am I sometimes!!)

Best regards
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24096279
so was it not quite the solution you wanted?
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question