Dear All,
I'm trying to import a quite large text file (25mb) I had this working
fine by using the transfertext command and having a schema.ini file,
however having changed the username and password for my connection to
SQL server all my tables and queries come with dbo attatched, which is
fine as I've now edited all the relevent code and macros.
However, on the transfer text command, it doesn't recognise the table I
want to import into, it says it can't find it.
I've edited it to put dbo.tablename and I've tried importing the file
through the menu and selecting the table from the list using the wizard
and it still can't find the table to import to.
Any ideas?
Matthew
I'm trying to import a quite large text file (25mb) I had this working
fine by using the transfertext command and having a schema.ini file,
however having changed the username and password for my connection to
SQL server all my tables and queries come with dbo attatched, which is
fine as I've now edited all the relevent code and macros.
However, on the transfer text command, it doesn't recognise the table I
want to import into, it says it can't find it.
I've edited it to put dbo.tablename and I've tried importing the file
through the menu and selecting the table from the list using the wizard
and it still can't find the table to import to.
Any ideas?
Matthew