microsoft access advanced training - importing data
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access advanced training - Importing data

microsoft access advanced training - Importing data

resolvedResolved · Low Priority · Version Standard

replyReply Tue 25 Sep 2007, 09:52Delegate Clare said...

Clare has attended:
Access Intermediate course

Importing data

How to I convert my excel file to a CSV so that I can import it easily into Access without worrying about formatting issues?

For upcoming training course dates see: Pricing & availability

replyReply Wed 3 Oct 2007, 13:58Trainer Amanda said...

RE: Importing data

Hi Clare

Thanks for your question.

In Excel, if you go to File - Save as, you will be able to select .csv as the file type under the Save as type dropdown at the bottom of the screen.

Amanda

 

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard