Convert your spaces to Commas and then under DATA use Text To Columns. Use Comma Separator to make your split.
One^Two^Three
One^^Three
One^Two
would become:
One,Two,Three
One,,Three
One,Two
which would drop into Columns A B and C.
Import those columns into Access.
---------------------------------
Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2ยข/min with Yahoo! Messenger with Voice.
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
