I have a user that needs to import a data file. The problem is that I used the transferspreadsheet function in the code to import the data. The import worked fine on my machine. However, on the user's end, her tables show up as "dbo.tmp" where mine just show up as "tmp" in the adp file. So when she imports the data it goes to a local table called "tmp" instead of going on the sql server table called "tmp". I tried having the import going to "dbo.tmpImport" but that created 2 tables instead of one...
I read a very recent thread where I could set up a dts package that can be called from my code - however I read somewhere else that SQL Server manager needs to be installed on the user's machine in order for them to have the right dll reference?
Is there a way where I can call the connection of the database before the table name so the data goes there?
Thanks,
Kristen
I read a very recent thread where I could set up a dts package that can be called from my code - however I read somewhere else that SQL Server manager needs to be installed on the user's machine in order for them to have the right dll reference?
Is there a way where I can call the connection of the database before the table name so the data goes there?
Thanks,
Kristen