Help Importing Excell Files

[swichman]

Can somebody help me with the below expression?

I am getting a syntax error.


Much appreciated.

Docmd.TransferSpreadsheet
(acImport,acSpreadsheetTypeExcel9,"DrawingsCurrentRevImport","C:
\Documents and Settings\swichman\My Documents\ABFJV\SubmittalReports/
PMIVExport.xls",,,)

 

[Guest]

Without even testing or looking up the function I notice a forward slash in
your path?

"C:\Documents and Settings\swichman\My
Documents\ABFJV\SubmittalReports/PMIVExport.xls"

Shouldn't it be

"C:\Documents and Settings\swichman\My
Documents\ABFJV\SubmittalReports\PMIVExport.xls"

 

[swichman]

Dan
I appreciate it. I changed it but it still will not work.
Sean

 

[Ken Snell \(MVP\)]

Eliminate the parentheses. You don't need them when using this VBA
statement.

 

[swichman]

Eliminate the parentheses. You don't need them when using this VBA
statement.

--

Ken Snell
<MS ACCESS MVP>









- Show quoted text -

STILL DOES NOT WORK. I FEEL LIKE AN IDIOT

 

[Ken Snell \(MVP\)]

Post the exact code that you're using now.