Answers inline...
--
Ken Snell
<MS ACCESS MVP>
Steve33029 said:
Dear Sir/Madam,
1) Excel has a proper function. Access does not. How can I use the proper
function from with Access?
ACCESS has a function in VBA named StrConv, which can be used to provide
"proper" capitalization. This function also can be called from within a
query.
2) How do I export data from Excel to a text file so that I can import
into
Access?
Not necessary. ACCESS has three ways that you can import data from EXCEL:
1) File | Get External Data | Import ... (note that this will
truncate any strings that are longer than 255 characters)
2) TransferSpreadsheet action in a macro (this will not cause
truncation)
3) DoCmd.TransferSpreadsheet method in VBA code (this will not cause
truncation)
Also, you can link to the data in an EXCEL spreadsheet:
File | Get External Data | Link Tables ...
Do note that ACCESS / Jet database engine may misinterpret some EXCEL data
as it scans the data -- it might think a column in EXCEL is numeric when it
doesn't contain letters in the first 8 or so rows, for example. So you may
need to do a few tweaks to get things to work as expected -- unless you're
using ACCESS 2007, which will let you declare the data type of the EXCEL
column.
3) Why does this Office suite NOT allow you to export from one product to
another with ease?
See above.
