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 ««12

SSIS: Importing Excel spreadsheet with more than 255 columns Expand / Collapse
Author
Message
Posted Tuesday, January 21, 2014 5:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:36 AM
Points: 30, Visits: 291
Does this have to be uploaded as an Excel file?, why not try .csv or .txt and then it should pull through?
Post #1532990
Posted Sunday, January 26, 2014 8:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 24, 2014 5:39 PM
Points: 3, Visits: 59
it's a file that will be supplied multiple times a day so it's not feasible to convert it every time.
Post #1534841
Posted Tuesday, January 28, 2014 2:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 27, 2014 1:57 PM
Points: 204, Visits: 1,328
"it's a file that will be supplied multiple times a day so it's not feasible to convert it every time."

Why?
You have to give us more background information.



"and contains macro's causing it to be a .xlsm file."
Why not cange that macro so the file format is .txt

This Little macro opens a .xlsm file and saves it as a .txt file

------
Workbooks.Open Filename:="XXXXX\YYYY.xlsm"

ActiveWorkbook.SaveAs Filename:="XXXXX\YYYY.txt", FileFormat:= _
xlText, CreateBackup:=False
------

Gosta M

Post #1535346
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse