We are looking at creating a large text file which we will link to in Access 97, and join with another large linked text file to create the set of data we need. Would that join be faster if we made that text file delimited or if we made it fixed length?
Thanks in advance for your help!
Anyone have a clue why this query is giving me errors in DTS? It totally crashes SQL Server:
INSERT INTO PriceList
(PriceList, Description, CreateDate, CreateUser,
MaintenanceDate, MaintenanceUser, UpMe)
VALUES (?,?,?,?,?,?,?)
if (select @@error) = 2627
UPDATE PriceList
SET...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.