aguynamedscotty
New Member
- Joined
- Sep 17, 2007
- Messages
- 1
Hi all,
I'm dealing with a client who recieves an email subscription via SQL Server (2008) Reporting Services, giving him a daily Excel spreadsheet. The four columns should be of data type integer, integer, date, integer - the SQL code used in the report is correctly generating this output. However, when he subsequently attempts to import his daily spreadsheet into an Access DB for his own use, his tables are creating with types number (but in double format, which he is having to manually change to "long integer") and the date column is coming through as text. Something's clearly being lost in translation, but I'm unsure if it's the export from SRS to Excel, or the import from Excel to Access, or both.
Any advice on the text box formatting in SRS to help me get to the end result of long integer and date in Access would be very much appreciated. TIA.
I'm dealing with a client who recieves an email subscription via SQL Server (2008) Reporting Services, giving him a daily Excel spreadsheet. The four columns should be of data type integer, integer, date, integer - the SQL code used in the report is correctly generating this output. However, when he subsequently attempts to import his daily spreadsheet into an Access DB for his own use, his tables are creating with types number (but in double format, which he is having to manually change to "long integer") and the date column is coming through as text. Something's clearly being lost in translation, but I'm unsure if it's the export from SRS to Excel, or the import from Excel to Access, or both.
Any advice on the text box formatting in SRS to help me get to the end result of long integer and date in Access would be very much appreciated. TIA.
