help needed with error 3011

[xmanin]

i have developed some functions in module using which i want to download CSV files from a Stock exchange server. everything is fine but i am unable to download CSV file, i get following msg "[COLOR="Red"]3011 The Microsoft Jet database engine could not find the object 'http://www.nseindia.com/content/historical/EQUITIES/2007/SEP/'. Make sure the object exists and that you spell its name and the path name correctly.[/COLOR]" however when i check the values in debug windows everything is fine even the file URL is constructed properly. for reference the code is

============================================
Option Explicit
 
Function ImportBhavCopy(dtFrom As Date, dtTo As Date)
On Error GoTo errHandler
Dim dtDate As Date
 
For dtDate = dtFrom To dtTo Step -1
    'Debug.Print GetURL(dtDate)
    DoCmd.TransferText acImportDelim, "", "Quotes", GetURL(dtDate), True, ""
Next
 
errHandler:
Debug.Print err.Number & " " & err.Description
Exit Function
End Function
Function GetURL(dtTemp As Date) As String
Dim strTemp As String
strTemp = "http://www.nseindia.com/content/historical/EQUITIES/"
strTemp = strTemp & GetYear(dtTemp) & "/"
strTemp = strTemp & UCase(GetMonthName(dtTemp)) & "/cm"
strTemp = strTemp & GetDay(dtTemp)
strTemp = strTemp & UCase(GetMonthName(dtTemp))
strTemp = strTemp & GetYear(dtTemp) & "bhav.csv"
GetURL = strTemp
End Function
 
Function GetMonthName(dtTemp As Date) As String
GetMonthName = MonthName(Month(dtTemp), True)
End Function
Function GetDay(dtTemp As Date) As String
If Day(dtTemp) < 10 Then
    GetDay = "0" & CStr(Day(dtTemp))
Else
    GetDay = CStr(Day(dtTemp))
End If
End Function
 
Function GetYear(dtTemp As Date) As String
GetYear = CStr(Year(dtTemp))
End Function
 
============================================
 

i will really appreciate if anyone can help me with this. i need this to be completed as soon as possible. need to submit this for a project.

[nico5038]

Could be a corruption sign as described in:
http://www.vb123.com/fixaccess/Acces...onProblems.htm

Some MS Access database recovery steps:

1) Create a backup of the corrupt database. (Just in case of)

2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.

3) Try these Microsoft solutions:
Repair A97/A2000:
http://support.microsoft.com/support.../Q109/9/53.asp
Jetcomp:
http://support.microsoft.com/default...;en-us;Q273956
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default...b;en-us;306204

4) Bit "heavier":
Access decompile:
http://www.granite.ab.ca/access/decompile.htm

5) Try a recovery tool / Table rescue
Table datarecovery:
www.mvps.org/access/tables/tbl0018.htm
Access recovery:
http://www.officerecovery.com/access/index.htm

6) Ask a company (will cost $$'s ! )
http://www.pksolutions.com/services.htm

check also: http://www.granite.ab.ca/access/corruptmdbs.htm

Nic;o)

[missinglinq]

While Access error messages are notorious for not being accurate, in this case, as the message says, the object

http://www.nseindia.com/content/historical/EQUITIES/2007/SEP/

does not exist! Try copying it and pasting it into your browser's address box. You have to take it all the way back to

http://www.nseindia.com/

before you can connect to the site. I think you need to check your references again for the correct URL.

Welcome to TheScripts!

Linq ;0)>