Importing an excel spreadsheet into Access2000

[leenabhanot]

Hi, I am building a web page which asks the user for a filename. I capture the filename but would like to feed it into the following VB command which imports the excel data into an access(2000) table.
DoCmd.TransferSpreadsheet acImport, 8, "UserIDTable", InputFileName, True

The problem I am having is in using either jsp or vbscript from within the web page to execute the above command. If I use the command in VB script I get an error message saying
"DoCmd" not valid.
I would really appreciat eany help possible.
Thanks

 

[KyleS]

Hi,
The "DoCmd" is only used in Access, so that's why it's not being recognized. Use VbScript to open access and run your line of code from within. I can't give you the sample code for that because I have never so much as seen VBScript. So I don't know what the syntax differences are between that and VB and VBA. Hopefully one of our colleagues will have an example for you.