upgrade of database from access to MSDE makes sql not work

[Knoxvile]

Hi

I have a small program that is taking data from a text file and updating a table in an access database. This was working fine until.... we upgraded the access database to a MSDE database.

Now when my code hits the line of code:myconnection.Execute "delete * from conloc where ContainerID in (select ContainerID from [Text;DATABASE=c:\file_extraction\TxtPickup].[filqasConLoc.txt]) "
it breaks down and doesn't want to work now that it is working with the MSDE database.
Does anyone know why this is happening or can give me any leads what to research.
Maybe I need to do stored procedures but have no idea how to actually go about it .

Can you help

rgds, Knoxvile

[si_the_geek]

it's due to this bit: from [Text;DATABASE=c:\file_extraction\TxtPickup].[filqasConLoc.txt])

but I don't know how you would do it in MSDE