[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to export a blank column from an Access db

Posted on 2009-04-08
4
Medium Priority
?
197 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
  • 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 1500 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

829 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