Text Import

[Yuppiest]

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

 

[SQL_Hell]

does your new login have database ownership permissions?

 

[Yuppiest]

Database Permissions

Thank you for your response,

The new username and password does have ownership permissions.

 

[SQL_Hell]

are you absolutely sure it is pointing at the right database?

try referencing it like

databasename.dbo.tablename

 

[Yuppiest]

Hi,

Thanks again,

I've tried typing the database name in but it just creates a new table called 'Databasename_dbo_tablename' on the import instead of putting it into the correct table.

It happens on any table, even if I create a new one. The adp is pointing to the correct database as every other aspect of the database is working, and on the sql side the tables have the right permissions.

I could use this new table but I have a problem with the dates as they come on in full date format when I need them in smalldatetime. Due to the large amounts of data if I try and convert it with a query I get an arithmatic overflow error.

this one has really stumped me as before the username and password change it was working fine.