AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Monday, October 23, 2006

Import or Link mixed type data from Excel

There is an interesting post “External Data - Mixed Data Types” in Daily Dose of Excel blog, which certainly applies to Access also. If you would import (or link, or select) data from Excel spreadsheet with mixed type of data and one column has numbers and text, then Jet makes a guess of what type of column should be in resulting set. And quite often could happen that this guess is wrong. The trick is to add IMEX=1 to connection string, then all resulting columns will have text type. Read mentioned post for more info.

2 Comments:

Blogger grovelli said...

Hi Alex,
Do you think you can set IMEX=1 if you're using the Import Spreadsheet Wizard?

1:36 PM  
Blogger Alex Dybenko said...

Hi Giorgio,
not sure, that you can set IMEX=1 when using Import Spreadsheet Wizard, unless you get wizards source and make modifications there (but not sure if this is allowed either)

2:37 PM  

Post a Comment

Links to this post:

Create a Link

<< Home