If you import from Acccess with the option in the Access menu, my answer will not help you.
I import using programs (VB 2005 specifically). The basic idea is:

Dim AppExcel As Excel.Applicati on
AppExcel = New Excel.Applicati on
AppExcel.Visibl e = False

Try
AppExcel.Workbo oks.Open(Filena me:=sFileName)
Catch ex As Exception
MessageBox.Show ("Unable...

Hi,

I'm having a problem related (I believe) with the scope of a function.

I wrote in Access 2003 the module A. It contains
Public Function B(ByVal s As String) As String
This function returns strings based on strings.

I got also a query Q1 that is basically
Select s, B(s) from Table

The query works well inside Access, but called from my VB.NET (express edition, 2005)...