How to Extract Tables from DB ..

03/10/2012 09:47 Neko_#1

Hello ..
i am trying to edit my DB , But i prefer to use Microsoft Excel instead of fast editing , etc ..

problem is , how to extract tables from DB , And re import it

03/10/2012 10:30 LastThief*#2

For re-importing

PHP Code:


			
BULK INSERT Table FROM 'path' WITH (FIELDTERMINATOR = '","')

Field Terminator decides how the fields will be added there is \t (for tab) and \n (for new line)