importing data into Access 2003

#1 (**permalink**) 28-Jul-2006, 08:11 AM

Good Evening All;

Our company is moving to Windows XP from 2000. Also, we are moving from
Access 2000 to Access 2003. I am finding that when I try to import text
files into my databases, I am receiving an error which says something like
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10265-importing-data-into-access-2003-a.html
'object not found in control', or 'control not found in object', and I am
unable to load the file. I tried converting my existing databases to 2003 as
well as create new ones in 2003, and I end up with the same result. Does
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10265
anyone have any insight to what causes this, and more importantly, have a
solution? I would greatly appreciate your help.

Thanks.

#2 (**permalink**) 28-Jul-2006, 08:11 AM

DG,

do you know how the text files are imported?.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10265

Regards,

Valentín

#3 (**permalink**) 28-Jul-2006, 08:12 AM

I have used both macros, as well as doing a simple paste append. I receive
the errors when I paste append. When I run the macros, nothing happens.

Thanks
"Valentín Playá" wrote in message
news:1148535833.113586.185550@y43g2000cwc.googlegr oups.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10265
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10265
DG,

do you know how the text files are imported?.

Regards,

Valentín

#4 (**permalink**) 28-Jul-2006, 08:12 AM

DG,

do you copy all text file from Notepad and paste it to an Access
table?. There no problems doing that others than controling the format.
As far as I know the behavior of Access 2000 and 2003 is the same.

You say running macros "nothing happens". Do this mean that works well
or that it doesnot work at all?. If it does not work, what does the
macro?

Regards,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10265
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10265

Valentín

#5 (**permalink**) 28-Jul-2006, 08:12 AM

Valentín

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10265
It turns out the we were missing the accwiz.dll file. I copied it back out
to the system folder and that took care of it. Thanks for following up.

"Valentín Playá" wrote in message
news:1148662473.668511.154140@j33g2000cwa.googlegr oups.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10265
DG,

do you copy all text file from Notepad and paste it to an Access
table?. There no problems doing that others than controling the format.
As far as I know the behavior of Access 2000 and 2003 is the same.

You say running macros "nothing happens". Do this mean that works well
or that it doesnot work at all?. If it does not work, what does the
macro?

Regards,

Valentín