8 Kicks

DTS, Excel and mixed format columns(geekzilla.co.uk)

submitted by phaymanphayman(3550) 4 years, 11 months ago

I recently had a problem DTS importing an Excel spreadsheet which contained columns with mixed text and data values. After a bit of hunting around, I found an extended property IMEX=1. The IMEX=1 property forces everything to text when reading from a source.

add a comment |category: |Views: 2

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
sporlegsporleg(0) - bclhaynesbclhaynes(0) - rhaymanrhayman(0) - fatdavehfatdaveh(1420)
More who kicked this story...
Comments:

No comments so far

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?