From Newsgroup: comp.databases.ms-access

How to add a blank column to a query for CSV export.

I need to transfer contacts between two old phones, for a friend. I can export and import CSV from each, but each uses a different layout so I'll
need to tweek.
For example, the field "Title" (for Mr, Mrs, Miss etc) is in the new but
not in the old. This means I'll need to create a blank, empty column
named "Title."

All clear, all easy, should be trivial BUT I cannot remember how to
create the new empty column without Access treating it as a parameter.
(Yes, I'm old.)

Here's a bit of basic SQL as an example.

SELECT GeorgeContacts.[First Name], GeorgeContacts.[Last Name], GeorgeContacts.[Mobile Phone]
FROM GeorgeContacts;

This gives three columns First Name, Last Name and Mobile Phone.

How do I get the result Title, First Name, Last Name and Mobile Phone?

For what it's worth, here's the format of the full list of headers for
old and new. Sorry if word-wrap causes a problem.

Old: Name,Given Name,Additional Name,Family Name,Yomi Name,Given Name Yomi,Additional Name Yomi,Family Name Yomi,Name Prefix,Name Suffix,Initials,Nickname,Short Name,Maiden Name,Birthday,Gender,Location,Billing Information,Directory Server,Mileage,Occupation,Hobby,Sensitivity,Priority,Subject,Notes,Langua ge,Photo,Group Membership,E-mail 1 - Type,E-mail 1 - Value,Phone 1 - Type,Phone 1 - Value,Phone 2 - Type,Phone 2 - Value,Address 1 -
Type,Address 1 - Formatted,Address 1 - Street,Address 1 - City,Address 1
- PO Box,Address 1 - Region,Address 1 - Postal Code,Address 1 - Country,Address 1 - Extended Address

New: "Title";"First name";"Middle name";"Last name";"Suffix";"Job title";"Company";"Birthday";"SIP address";"Push-to-talk";"Share
view";"User ID";"Notes";"General mobile";"General phone";"General e- mail";"General fax";"General video call";"General web address";"General
VOIP address";"General P.O.Box";"General extension";"General
street";"General postal/ZIP code";"General city";"General state/province";"General country/region";"Home mobile";"Home phone";"Home e-mail";"Home fax";"Home video call";"Home web address";"Home VOIP address";"Home P.O.Box";"Home extension";"Home street";"Home postal/ZIP code";"Home city";"Home state/province";"Home country/region";"Business mobile";"Business phone";"Business e-mail";"Business fax";"Business video call";"Business web address";"Business VOIP address";"Business P.O.Box";"Business extension";"Business street";"Business postal/ZIP code";"Business city";"Business state/province";"Business
country/region";""

I could type them all in, of course, but there's nearly 500 and I'm lazy
(and old.)

All help gratefully received.
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ms-access

on 8/14/2022, Alan Carpenter supposed :

SELECT GeorgeContacts.[First Name], GeorgeContacts.[Last Name], GeorgeContacts.[Mobile Phone]
FROM GeorgeContacts;

Try

SELECT "" as Title, GeorgeContacts.[First Name], GeorgeContacts.[Last Name],GeorgeContacts.[Mobile Phone]
FROM GeorgeContacts;

Rdub
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ms-access

Ron Weiner <rw@domain.com> wrote in news:tdb0vv$35u42$1@dont-email.me:

SELECT "" as Title, GeorgeContacts.[First Name], GeorgeContacts.[Last Name],GeorgeContacts.[Mobile Phone]
FROM GeorgeContacts;

... which of course is exactly what I wanted.

I would swear on a stack of database manuals I tried that more than once.
Oh well, I hope I like it in the Senile Care home I seem to be heading for.

Thanks for that. Take the rest of the day off.
--- Synchronet 3.21b-Linux NewsLink 1.2