No announcements
Found 3428631 threads
-
0 VotesMS AC 2010: How data is stored on the disk/exported to text file.
How many are field are we talking about?Answered | 6 Replies | 544 Views | Created by CTBarbarin - Thursday, May 26, 2016 5:48 PM | Last reply by Peter N Roth, Author of Ten Commandments of VBA - Saturday, May 28, 2016 8:12 PM
-
12 Votes
Exporting table data into text files
BCP can auto-generate the control file as it exports the data.Answered | 31 Replies | 7815 Views | Created by TheBrenda - Monday, August 18, 2014 3:52 PM | Last reply by jrv - Monday, September 22, 2014 8:11 PM -
3 Votes
how to export data from MS Project 2010 to MS Excel 2010 with formatting
I have successfully exported the data from MS Project 2010 file to Excel 2010 using Project VBA.Answered | 5 Replies | 25331 Views | Created by Yogesh Garg - Wednesday, December 7, 2011 5:26 AM | Last reply by Dale Howard [MVP] - Wednesday, February 26, 2014 2:00 PM -
0 Votes
how to export data to ms word in light switch
Hi ...Answered | 3 Replies | 3794 Views | Created by gsr.srikar - Tuesday, December 13, 2011 9:41 AM | Last reply by Spaso Lazarevic - Thursday, December 15, 2011 8:32 AM -
0 Votes
Export SQL Data to Text File
Thank You Guys, Can you please give me the complete SP code against my SP, I am first time using this BCP utility, so don't know how to compose it?Answered | 4 Replies | 3512 Views | Created by anwar.mustafa - Sunday, February 10, 2013 9:34 PM | Last reply by DVR Prasad - Monday, February 11, 2013 9:38 AM -
1 Votes
Exporting encrypted data to a text file
\pipe\LO CALDB#092D34E7\tsql\query -T -n I am trying to export the encrypted data to a local db instance.Answered | 3 Replies | 11554 Views | Created by dnaman - Friday, May 13, 2011 4:08 PM | Last reply by Sudhev - Tuesday, May 15, 2012 10:43 AM -
0 Votes
SQL Export Data to Custom text file
You already know how to generate your data file.Answered | 5 Replies | 6616 Views | Created by IMITAZ - Thursday, June 21, 2012 4:38 PM | Last reply by IMITAZ - Monday, June 25, 2012 3:27 PM -
0 Votes
How to Export a store procedure output to Excel File
Hi Muqadder, I'm facing a problem to export result of stored procedure into excel file. after writting exec sp_<storedprocedure name> I'm getting ...Answered | 8 Replies | 16468 Views | Created by devpan - Saturday, May 7, 2011 3:25 AM | Last reply by K_Kalyan - Tuesday, September 26, 2017 3:19 PM -
0 Votes
Export data from SQL server table to a text file
Hi All, I need to export some data from SQL Server (2008 R2) table to a text file.Answered | 2 Replies | 3256 Views | Created by Rocky_SQL_DBA - Wednesday, August 29, 2012 7:35 PM | Last reply by btsbee - Wednesday, August 29, 2012 9:57 PM -
10 Votes
How clustered index stored on disk ?
When taken literally, it means that the index data would be stored on consecutive sectors of consecutive tracks of the magnetic disk.Answered | 6 Replies | 14020 Views | Created by SmartWhy - Sunday, August 11, 2013 1:50 PM | Last reply by Dan Guzman - Sunday, August 11, 2013 8:02 PM -
1 Votes
How to Export SQL data to text file
Hi Suresh-M, i need to compare the student id and fetch the data (Student id, name ,age,address,gender,grade)then overwrite in to same text file ...Answered | 9 Replies | 1586 Views | Created by Suresh-M - Friday, March 8, 2019 6:50 AM | Last reply by Visakh16 - Tuesday, March 19, 2019 10:40 AM -
0 Votes
Export data using stored procedure to excel
Or a totally flexible process that you can input any table name and it will export?Answered | 6 Replies | 30058 Views | Created by AbhinavSultania - Thursday, November 6, 2014 8:25 AM | Last reply by Ankur Kr. Gupta - Friday, December 16, 2016 5:46 AM -
0 Votes
Export data into new text file on daily basis
Hi, Here is step by step demo, how to create an SSIS Package that should read the data from sql table and create text file.Answered | 2 Replies | 1123 Views | Created by KrishReddy - Tuesday, May 31, 2016 1:04 PM | Last reply by Aamir Shahzad Warraich - Thursday, June 2, 2016 7:49 PM -
0 Votes
how to export data to ms word
Hi You have a couple of good blog post regarding this topis such as: Office Integration Pack - Custom ...Answered | 1 Replies | 2340 Views | Created by gsr.srikar - Wednesday, December 7, 2011 6:59 AM | Last reply by Spaso Lazarevic - Wednesday, December 7, 2011 7:13 AM -
1 Votes
MS SQL Server 2012 and MS ACCESS 2010
Are there any issues on the MS Acess 2007 connecting to SQL Server 2010?Answered | 5 Replies | 10210 Views | Created by Chapht - Tuesday, July 2, 2013 2:26 PM | Last reply by Gilbert Allan Wong - Wednesday, December 25, 2013 1:30 PM -
0 Votes
Export data to text, how to alignment.
Tabs don't have a pre-fixed "space-length", and it's up to the implementor to choose how he wants to render tabs.Answered | 2 Replies | 3020 Views | Created by Victor Ge - Tuesday, July 21, 2009 2:47 AM | Last reply by Nishant Sivakumar - Tuesday, July 21, 2009 4:37 PM -
0 Votes
How to store text file in database
In that case you can store the files on the file system and store in the table only the path to the files.Answered | 4 Replies | 4107 Views | Created by miruan - Wednesday, January 30, 2013 5:53 AM | Last reply by Kalman Toth - Wednesday, January 30, 2013 2:44 PM -
0 Votes
How to move data into text file
Using xp_cmdshell and BCP output data into that text file.Answered | 14 Replies | 4573 Views | Created by anurag.sharma - Monday, April 30, 2012 5:38 PM | Last reply by anurag.sharma - Tuesday, August 21, 2012 11:52 AM -
0 Votes
Exporting data to excel file
You can have a table to insert (from within a trigger) the needed data into a permannet table and then probably better would using SSIS to insert the data into EXCELBest ...Answered | 8 Replies | 1444 Views | Created by Mazhar_Parkar - Tuesday, November 18, 2014 4:57 AM | Last reply by ryguy72 - Monday, December 8, 2014 6:19 PM -
2 Votes
How to store a text file into an array?
Hi, We can store text of file line by line with following code...Answered | 3 Replies | 649 Views | Created by Xeni_Xeni - Friday, November 27, 2015 10:04 AM | Last reply by Xeni_Xeni - Friday, November 27, 2015 5:08 PM - Items 1 to 20 of 3428631 Next ›
No announcements
