load a table from servlet

[dinger]

Hello,
I have a client who downloads data from a website. I must then put this data into an access database. The problem I am having is that the file is a strange format - it comes to me as filename.servlet[3]

I am assuming that this is some kind of java file, but am not really sure. I can open it with notepad and it looks like a comma delimited file, but i can't figure out how to get it into an access table.

Does anyone have any idea how to handle this file?

Any thoughts would be appreciated.

Thanks.

 

[dinger]

FYI - Problem solved

Hello,
Just wanted to let everyone know that I was able to solve this issue.
I loaded the data by opening the .servlet file in excel using vba and saved it as a text file.
I then used docmd.TransferText to put the data into the table. I used an append query afterwords to clean up the imported data (get rid of some double quotes, etc.) and append it to a new table.

Let me know if anyone has any questions regarding what I did to accomplish this.

Thanks