> Support > Database Marketing > Contact Management > Creating a CSV file from Microsoft Access

Creating a CSV file from Microsoft Access


Creating a CSV file from Microsoft Access (database) is similar to that from Excel, but there are a few more steps. Fortunately a "wizard" helps you through the stages.

With Access running, and the data being displayed in a table:

  1. From the menu select "File" and then "Save As/Export..."
  2. On the first window just press OK
  3. On the next window
  4. From the "Save as type:" drop down list, select "Text Files (*.txt;*.csv;*.tab;*.asc)" 
  5. Give your file a meaningful name, and add the .csv extension instead of the .txt extension
  6. Make sure that the checkbox "save formatted" is empty
  7. Click in the button marked "Export"
  8. Next screen:
  9. Just click "next..." and on the next screen, change "Text Qualifier" to {none}
  10. Then click "next..." and finally: name the file with a .csv extension, and click on "Finish"

You may also be interested in...

Was this information helpful?
Rating:  
12345 

Assess your website for FREE!

Enter your website URL, and within seconds we'll let you know where your website's strengths and weaknesses lie.

 

CHECK OUT OUR LATEST BLOGS

Ignite your website with helpful tips and strategies
from Bloomtools’ team of expert marketers.

The Top Five Reasons For Why Your Marketing Strategy Needs A Thank You Page

Posted by Bloomtools Canada on 22 June 2023
The Top Five Reasons For Why Your Marketing Strategy Needs A Thank You Page
When a visitor completes a particular action on a website, such as filling out a form, signing up for a newsletter, or completing a purchase, a tha...
Posted in:Content MarketingNewsWebsite PerformanceLead Generation   Comments

Growth Hacker Marketing: The Future Of Modern Marketing

Posted by Bloomtools Canada on 11 June 2023
Growth Hacker Marketing: The Future Of Modern Marketing
Between work and personal notifications on our laptops, smartphones and apple watches, sending marketing messages through modern-day technology is ...
Posted in:Content MarketingNewsSearch Engine MarketingInternet MarketingOnline Marketing   Comments

Understanding Secondary CTAs: Everything You Need to Know

Posted by Bloomtools Canada on 26 April 2023
Understanding Secondary CTAs: Everything You Need to Know
How do Secondary CTAs work?A secondary CTA is a call-to-action that provides an alternative conversion opportunity or action to the primary action ...
Posted in:WebsiteWeb Development   Comments
< Previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next >
PrintTell a FriendBookmark Site