Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import flat file into existing table using wizard Expand / Collapse
Author
Message
Posted Wednesday, July 02, 2008 8:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 02, 2012 11:25 AM
Points: 27, Visits: 73
How do you import data into an existing table using the import wizard? It doesn't seem to allow that function. I can import data into a new table, but not add data to an existing one.

But I haven't played around with the Wizard that much yet.

Thanks.
Post #527343
Posted Wednesday, July 02, 2008 8:42 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 4,056, Visits: 5,182
I haven't had any problem importing data to an existing table. Do you get any error messages?

Greg
Post #527383
Posted Wednesday, July 02, 2008 12:50 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:34 PM
Points: 15,442, Visits: 9,588
Where it displays the target table, you can either type in an existing table, or click the down-arrow next to that and it will let you select an existing table.

Make sure you click the Mappings button if you do that, to make sure columns will end up in the right places.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #527535
Posted Thursday, July 03, 2008 12:54 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 25, 2010 6:09 AM
Points: 1,621, Visits: 409
Hi,
Please let us if you are facing any problem. If youa re not clear on the process then Check out the below link
http://support.microsoft.com/default.aspx/kb/321686
Thanks -- VJ
http://dotnetvj.blogspot.com


Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers



Post #528342
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse