Encore Forums Encore Forums

Knowledgebase  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

Creating .csv files in MSAccess

 
Logged in as: Guest
  Printable Version
All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC Export/Import >> Creating .csv files in MSAccess Page: [1]
Login
Message << Older Topic   Newer Topic >>
Creating .csv files in MSAccess - 6/24/2010 4:02:06 PM   
bbodzin

 

Posts: 1
Joined: 6/24/2010
Status: offline
How do I create a .csv file to use as input for my event list? My data is in MSAccess and I can't write it in .csv format. I am running Microsoft Office 2007 on Windows XP. Thanks.

< Message edited by Brandy redux -- 9/17/2010 7:46:46 PM >
Post #: 1
RE: Creating .csv files in MSAccess - 6/24/2010 4:24:32 PM   
Brandy redux


Posts: 2376
Joined: 2/7/2007
Status: offline
Hi bbodzin,

Since the *.csv format is, actually, nothing more than a *.txt file with a different file extension, you would export the MSAccess file to *.txt format then rename the file with a *.csv extension.

1. Open the MSAccess file.

2. Click on the 'External Data' tab.

3. Click on 'Text File'.

4. Follow through with the steps for exporting the MSAccess file as a *.txt file.

5. After the *.txt file has been successfully exported, right click on the *.txt file, select 'Rename' in the menu that drops down, then change the extension to *.csv.

< Message edited by Brandy redux -- 9/17/2010 7:46:55 PM >


_____________________________

For More Help:
Click on the FAQ link at the top of this page
Then, click on the All FAQ's button on the next page

To contact me by email, please send your message to pine_97@yahoo.com

(in reply to bbodzin)
Post #: 2
Page:   [1]
All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC Export/Import >> Creating .csv files in MSAccess Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Please Note: In order to post a message on the forums, you will need to become an Encore Forum Member. Click on the Register link on the top of this page and follow the instructions to become an Encore Forum Member.

If you are a new member and need help using these forums, please click on the FAQ link at the top of this page.

Forum Software © ASPPlayground.NET Advanced Edition 2.4

1.219