dbTalk Databases Forums  

Importing from formatted Excel cells using SQL Server 2000 DTS Iss

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Importing from formatted Excel cells using SQL Server 2000 DTS Iss

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Importing from formatted Excel cells using SQL Server 2000 DTS Iss in the microsoft.public.sqlserver.dts forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
Darren
 
Posts: n/a

Default RE: Importing from formatted Excel cells using SQL Server 2000 DTS - 12-13-2008 , 12:56 PM





I am using SQL 2000 DTS and I hadalready added IMEX=1 to the extended
properties for the Excel connection.

"Todd C" wrote:

Quote:
Are you using DTS or SSIS?
If SSIS, Try an OLE Db connection for Jet 4.0. In the Connection String
Extended Properties, add the following:

Excel 8.0;IMEX=1;HDR=Yes

The IMEX=1 delays type validation.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Darren" wrote:

We have an Excel workbook where certain cells are formatted not to show the
decimal places (formatted as number with zero decimal places).

As a result of the formatting, the data imported is also without decimal
places and this gives issues with the final results of my SQL queries due to
value rounding at the source.

Is it possible to import the true figures contained within the workbook
without the need to re-format the cells to show the decimals prior to import?

Reply With Quote
  #12  
Old   
Darren
 
Posts: n/a

Default RE: Importing from formatted Excel cells using SQL Server 2000 DTS - 12-13-2008 , 12:56 PM





I am using SQL 2000 DTS and I hadalready added IMEX=1 to the extended
properties for the Excel connection.

"Todd C" wrote:

Quote:
Are you using DTS or SSIS?
If SSIS, Try an OLE Db connection for Jet 4.0. In the Connection String
Extended Properties, add the following:

Excel 8.0;IMEX=1;HDR=Yes

The IMEX=1 delays type validation.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Darren" wrote:

We have an Excel workbook where certain cells are formatted not to show the
decimal places (formatted as number with zero decimal places).

As a result of the formatting, the data imported is also without decimal
places and this gives issues with the final results of my SQL queries due to
value rounding at the source.

Is it possible to import the true figures contained within the workbook
without the need to re-format the cells to show the decimals prior to import?

Reply With Quote
  #13  
Old   
Darren
 
Posts: n/a

Default RE: Importing from formatted Excel cells using SQL Server 2000 DTS - 12-13-2008 , 12:56 PM


I am using SQL 2000 DTS and I hadalready added IMEX=1 to the extended
properties for the Excel connection.

"Todd C" wrote:

Quote:
Are you using DTS or SSIS?
If SSIS, Try an OLE Db connection for Jet 4.0. In the Connection String
Extended Properties, add the following:

Excel 8.0;IMEX=1;HDR=Yes

The IMEX=1 delays type validation.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Darren" wrote:

We have an Excel workbook where certain cells are formatted not to show the
decimal places (formatted as number with zero decimal places).

As a result of the formatting, the data imported is also without decimal
places and this gives issues with the final results of my SQL queries due to
value rounding at the source.

Is it possible to import the true figures contained within the workbook
without the need to re-format the cells to show the decimals prior to import?

Reply With Quote
  #14  
Old   
Darren
 
Posts: n/a

Default RE: Importing from formatted Excel cells using SQL Server 2000 DTS - 12-13-2008 , 12:56 PM


I am using SQL 2000 DTS and I hadalready added IMEX=1 to the extended
properties for the Excel connection.

"Todd C" wrote:

Quote:
Are you using DTS or SSIS?
If SSIS, Try an OLE Db connection for Jet 4.0. In the Connection String
Extended Properties, add the following:

Excel 8.0;IMEX=1;HDR=Yes

The IMEX=1 delays type validation.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Darren" wrote:

We have an Excel workbook where certain cells are formatted not to show the
decimal places (formatted as number with zero decimal places).

As a result of the formatting, the data imported is also without decimal
places and this gives issues with the final results of my SQL queries due to
value rounding at the source.

Is it possible to import the true figures contained within the workbook
without the need to re-format the cells to show the decimals prior to import?

Reply With Quote
  #15  
Old   
Darren
 
Posts: n/a

Default RE: Importing from formatted Excel cells using SQL Server 2000 DTS - 12-13-2008 , 12:56 PM


I am using SQL 2000 DTS and I hadalready added IMEX=1 to the extended
properties for the Excel connection.

"Todd C" wrote:

Quote:
Are you using DTS or SSIS?
If SSIS, Try an OLE Db connection for Jet 4.0. In the Connection String
Extended Properties, add the following:

Excel 8.0;IMEX=1;HDR=Yes

The IMEX=1 delays type validation.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Darren" wrote:

We have an Excel workbook where certain cells are formatted not to show the
decimal places (formatted as number with zero decimal places).

As a result of the formatting, the data imported is also without decimal
places and this gives issues with the final results of my SQL queries due to
value rounding at the source.

Is it possible to import the true figures contained within the workbook
without the need to re-format the cells to show the decimals prior to import?

Reply With Quote
  #16  
Old   
Darren
 
Posts: n/a

Default RE: Importing from formatted Excel cells using SQL Server 2000 DTS - 12-13-2008 , 12:56 PM


I am using SQL 2000 DTS and I hadalready added IMEX=1 to the extended
properties for the Excel connection.

"Todd C" wrote:

Quote:
Are you using DTS or SSIS?
If SSIS, Try an OLE Db connection for Jet 4.0. In the Connection String
Extended Properties, add the following:

Excel 8.0;IMEX=1;HDR=Yes

The IMEX=1 delays type validation.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Darren" wrote:

We have an Excel workbook where certain cells are formatted not to show the
decimal places (formatted as number with zero decimal places).

As a result of the formatting, the data imported is also without decimal
places and this gives issues with the final results of my SQL queries due to
value rounding at the source.

Is it possible to import the true figures contained within the workbook
without the need to re-format the cells to show the decimals prior to import?

Reply With Quote
  #17  
Old   
Darren
 
Posts: n/a

Default RE: Importing from formatted Excel cells using SQL Server 2000 DTS - 12-13-2008 , 12:56 PM


I am using SQL 2000 DTS and I hadalready added IMEX=1 to the extended
properties for the Excel connection.

"Todd C" wrote:

Quote:
Are you using DTS or SSIS?
If SSIS, Try an OLE Db connection for Jet 4.0. In the Connection String
Extended Properties, add the following:

Excel 8.0;IMEX=1;HDR=Yes

The IMEX=1 delays type validation.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Darren" wrote:

We have an Excel workbook where certain cells are formatted not to show the
decimal places (formatted as number with zero decimal places).

As a result of the formatting, the data imported is also without decimal
places and this gives issues with the final results of my SQL queries due to
value rounding at the source.

Is it possible to import the true figures contained within the workbook
without the need to re-format the cells to show the decimals prior to import?

Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top