No announcements
Found 3486456 threads
-
0 VotesHow to convert Excel file in csv ?
If you'd use an Excel with strings during design time, he will probably take those datatypes and remember them.Answered | 10 Replies | 4298 Views | Created by KiaraFR - Wednesday, December 14, 2011 1:57 PM | Last reply by KiaraFR - Friday, December 16, 2011 8:58 AM
-
1 Votes
How to convert xsl or xlsx to pdf
You'd probably have much more luck writing a console application that uses Excel.Answered | 2 Replies | 3144 Views | Created by Brooke Burke-Charvet - Thursday, July 25, 2013 10:51 AM | Last reply by Alex Brassington - Thursday, July 25, 2013 3:59 PM -
2 Votes
Converting .csv to .xls
When importing a .csv file into a table (using a TransferText command), I kept getting import errors.Answered | 5 Replies | 2777 Views | Created by Kenrav - Saturday, October 22, 2011 6:43 PM | Last reply by Andrey Artemyev - Saturday, October 22, 2011 7:37 PM -
5 Votes
Convert html to Excel (xslx format)
The application allows to save it as both xlsx and xls.Answered | 9 Replies | 64860 Views | Created by Emzo - Tuesday, June 5, 2012 11:25 AM | Last reply by kay114 - Tuesday, August 12, 2014 6:43 AM -
2 Votes
Convert .xls to .xlsx via BizTalk
If you really want to do it, then you could read the message and use Excel Object model to open the xls file and save it to xlsx file.Answered | 2 Replies | 5068 Views | Created by ashleyT2 - Friday, June 1, 2012 4:19 PM | Last reply by Ruth Resende - Friday, June 1, 2012 5:56 PM -
0 Votes
Docmd.OutputTo to Excel - type XLSX ?
I'm exporting a query to Excel using Docmd.OutputTo.Answered | 1 Replies | 5316 Views | Created by AllTheGoodNamesWereTaken - Wednesday, February 20, 2013 4:56 PM | Last reply by Daniel Pineault (MVP) - Wednesday, February 20, 2013 5:17 PM -
1 Votes
Convert excel .xlsx to .csv using Powershell
It worked great for me, I am using this with Excel 2019.Answered | 6 Replies | 30992 Views | Created by Jiniv Thakkar - Wednesday, November 16, 2016 6:49 PM | Last reply by luke79IRL - Monday, December 9, 2019 9:02 AM -
0 Votes
Custom pipeline to convert .XSLX to .CSV in Biztalk
Custom pipeline to convert .XSLX to .CSV in Biztalk Do you have a question or have a specific problem?Answered | 3 Replies | 994 Views | Created by RVReddy - Friday, May 22, 2015 6:12 PM | Last reply by Angie Xu - Tuesday, June 9, 2015 7:02 AM -
0 Votes
Problem while importing CSV and Excel files
Now the problem is in Excel file import I am using following code to read it .Answered | 17 Replies | 5207 Views | Created by NK sharma - Monday, July 8, 2013 3:25 PM | Last reply by NK sharma - Thursday, July 18, 2013 9:59 AM -
1 Votes
Visual Studio 2015 - connecting to Excel and CSV
Navigate to a folder that has oth a .xlsx file and a .csv file.Answered | 4 Replies | 5764 Views | Created by Joseph_at_MaRS - Wednesday, March 23, 2016 2:25 PM | Last reply by jr7138 - Thursday, November 14, 2019 3:42 PM -
0 Votes
powershell export as exel
It includes a PS script to convert CSV files into Excel.Answered | 3 Replies | 2301 Views | Created by orange juice jones - Monday, January 13, 2014 3:56 PM | Last reply by Steven Andrews - Tuesday, January 14, 2014 10:32 AM -
1 Votes
Export to Excel with .xlsx format
The MSDN page for the TransferSpreadsheet Method and AcSpreadSheetType Enumeration does not mention this constant.Answered | 4 Replies | 34121 Views | Created by ChristerB - Monday, September 12, 2011 1:41 PM | Last reply by nanochem - Tuesday, March 18, 2014 7:51 PM -
0 Votes
How to Convert part of /partial .xlsx to text file (as a csv)
Asitti - If you can make the table of data that you want into a named range in the source excel sheet, then you can actually reference the named ...Answered | 3 Replies | 2783 Views | Created by asitti7 - Monday, November 21, 2011 10:05 PM | Last reply by Brent Greenwood - Tuesday, November 22, 2011 3:15 PM -
0 Votes
From csv to excel using SSIS.
Excel can open csv file itself.Answered | 2 Replies | 943 Views | Created by DIEGOCTN - Thursday, January 15, 2015 2:06 PM | Last reply by ArthurZ - Thursday, January 15, 2015 2:28 PM -
2 Votes
Convert csv file to xls using VB
Are you using a 2007/2010 Excel file format?Answered | 13 Replies | 15216 Views | Created by Stergios73 - Monday, January 30, 2012 1:16 PM | Last reply by Paul P Clement IV - Tuesday, January 31, 2012 6:09 PM -
0 Votes
Best way to convert large xlsx file into tab delimited text file using script
One question: when using the Microsoft Office Interop DLL for Excel, do you really need to have the actual Excel application installed in order to ...Answered | 5 Replies | 4239 Views | Created by maggie0099 - Thursday, May 31, 2018 8:24 PM | Last reply by Jesus Varela - Wednesday, October 31, 2018 9:29 PM -
0 Votes
Excel XLSX format as a source
I installed the older one at https://www.microsoft.com/en-us/download/details.aspx?Answered | 8 Replies | 2524 Views | Created by olivernm - Tuesday, February 2, 2016 9:23 PM | Last reply by olivernm - Friday, February 19, 2016 6:21 PM -
0 Votes
PowerShell CSV - Modify CSV in a folder
https://docs.microsoft.com/en-us/answers/topics/windows-server-powershell.html & ...Answered | 2 Replies | 2281 Views | Created by DevilGemini - Saturday, October 17, 2020 5:08 AM | Last reply by Robotitude - Sunday, October 18, 2020 8:29 PM -
0 Votes
Can BCP Export To XLSX
Hello, None of the SQL Server tools = bcp, SqlCmd, Import/Export Wizard or SSIS supports formatting XLSX file, they all export it as plain Excel files without any ...Answered | 2 Replies | 5804 Views | Created by IndigoMontoya - Thursday, November 10, 2016 8:41 PM | Last reply by Olaf Helper - Friday, November 11, 2016 4:58 AM -
0 Votes
excel or csv is fast
As ETL said I too prefer csv over ETL.Answered | 2 Replies | 4328 Views | Created by BLR_ETL - Monday, May 10, 2010 9:24 AM | Last reply by Sudeep Raj - Monday, May 10, 2010 9:42 AM
No announcements
