I have been searching for hours on this stump I ran into. I have a RMA database in SQL Server 2000. I also have UPS Worldship automatically exporting into a csv file on the server with shipment information. I have setup a DSN for the csv also. On my view_rma.asp I view details about certain RMA's. The page uses an include to connect to the system DSN.
How do you code the view_rma.asp SQL or DSN's to query 2 DSN's at the same time? The first DSN to get RMA details and the second to get the UPS info?
UPS doesnt support automatic export into .mdb :( Otherwise I would be fine.
I also tried linking to the csv from within the Access Project but no luck. Linking only works in an mdb.
Can anyone help me please?
Thanks,
X-CentricSmells like a candidate for BULK INSERT (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_4fec.asp) to me. Suck the CSV file into a table, and forget about the DSN issues!
-PatP
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment