On Thu, 15 May 2008 18:19:30 -0700 (PDT), Roger
<le*********@natpro.comwrote:
>On May 15, 3:45*pm, PW <paulremove_williamson...@removehotmail.com>
wrote:
>Does the worksheet have to be exported to a CSV file first or can
Access import directly from an Excel workbook (.xls)?
Thanks,
-paulw
access with handle either based on how you create the link table
Would you explain "create the link table" further"? Your response to
my previous post:
>create a linked table to your excel worksheet
then use an insert query to populate your table
<
I did not know a link could be pointed to an Excel file. I do not
know the name of the file until the user selects it in a dialog box
like so:
strFilter = ahtAddFilterItem(strFilter, "Comma Seperated Value Files
(*.csv)", "*.CSV")
strReturnVal = ahtCommonFileOpenSave(Filter:=strFilter, _
OpenFile:=True, _
DialogTitle:="Please select the document...", _
Flags:=ahtOFN_HIDEREADONLY)
How would I then link to that file in code?
Thanks!
-pw