you can create an import specifications sheet and tell Access what data type
each column is.
John
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of wharmon97
Sent: Tuesday, May 09, 2006 2:32 PM
To: [email protected]
Subject: [ms_access] Re: Problem linking to an Excel worksheet
Found a solution.
Apparently you have to add an apostrophe to the beginning of each cell
in the column that you want to link as text. Set up a macro to do that
and it works just fine.
Wasted a couple of hours figuring it out.
Access and Excel seems to be very stubborn when looking at the first 10
or so rows to determine type. I hoped reversing my sort to put the
alphanumeric rows first would do the trick, but can you say NOT! The
alphanumeric entries did fine and the numerics were nailed with a #NUM!
The apostrophe trick worked just fine (except it means that each cell
in the selected column now has an apostrophe which is not real data).
Thanks.
SPONSORED LINKS
Microsoft
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+
access+database&w2=Database+development+software&w3=Database+management+soft
ware&w4=Database+software&w5=Inventory+database+software&w6=Membership+datab
ase+software&c=6&s=190&.sig=hc7Za8QzEj1t7F8GW0yzhA> access database
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Micros
oft+access+database&w2=Database+development+software&w3=Database+management+
software&w4=Database+software&w5=Inventory+database+software&w6=Membership+d
atabase+software&c=6&s=190&.sig=i5H8GCn7HzmglwpvhJg19w> development
software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Microso
ft+access+database&w2=Database+development+software&w3=Database+management+s
oftware&w4=Database+software&w5=Inventory+database+software&w6=Membership+da
tabase+software&c=6&s=190&.sig=kzlRmjQuUTEFLTjkEd6-kg> management software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+software&w1=Microsoft+access+d
atabase&w2=Database+development+software&w3=Database+management+software&w4=
Database+software&w5=Inventory+database+software&w6=Membership+database+soft
ware&c=6&s=190&.sig=CoCmr_EubT5Xd83NiQjcpg> software
Inventory
<http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Microsof
t+access+database&w2=Database+development+software&w3=Database+management+so
ftware&w4=Database+software&w5=Inventory+database+software&w6=Membership+dat
abase+software&c=6&s=190&.sig=DHnS8Uu1ImyGVg1J4k0BMw> database software
Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Microso
ft+access+database&w2=Database+development+software&w3=Database+management+s
oftware&w4=Database+software&w5=Inventory+database+software&w6=Membership+da
tabase+software&c=6&s=190&.sig=uEGHlFpqbscHu8mCHe7tzg> database software
_____
YAHOO! GROUPS LINKS
* Visit your group "ms_access
<http://groups.yahoo.com/group/ms_access> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
_____
[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.
