Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Assigning a Macro to a Keyboard Combination

Creating Scenarios

Using Message Boxes

Understanding Phantom Macros

Picking a Group of Cells

Running Out of Memory

Hiding Rows Based on a Cell Value

 

Working with Access

Tips, Tricks, and Answers

The following articles are available for the 'Working with Access' topic. Click the article's title (shown in bold) to see the associated article.

Conditional Formatting with Data Imported from Access
If the information you import from Access into Excel isn't interpreted just right, it can have consequences on your conditional formatting. This tip explains those consequences and how you can correct for any potential problems.

Preparing Data for Import into Access
When importing Excel information into Access, you need to be concerned with the condition of the data. Here's how to make sure that two common offenders—Social Security Numbers and ZIP Codes—are imported properly.