>- see footer for list info -< This has got to be easier than it appears. A friend has an Access db (handful of tables with just data, no constraints, etc) on his workstation and a hosting package which comes with SQL Server. He can't connect to SQL Server remotely, but can upload ".sql" files to the server. I've got a copy of MSDE running here and to help him out, figured it would be a piece of the proverbial to run the Access upsize into MSDE, then use some Enterprise Manager built-in functionality to spit out the data in one ".sql" file.
Well, now it's in MSDE, it's easy enough to export the schema using EM and get a ".sql" file with the necessary commands to recreate the structure, but it doesn't contain the data. If I go down the Export Data... Route and use DTS Import/Export Wizard, and select an SQL Server > Text file route, the text file just contains the data, without the required SQL statements to execute to import that data at the other end. And, boning up on "bcp", it doesn't seem to provide an option that allows you to dump the data with the required SQL to import it at the other end either. Please tell me there's an easy way to do this? -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
