Import wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When importing data from Excel to Access, even if the first few rows of data
in a field is text and then there is a number after this, this results in a
data type error and the wizard does not import.

The option of forcing all data to text appears dimmed. This provision should
be enabled.

Sajit Viswan

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...be9b2&dg=microsoft.public.access.externaldata
 
Sajit

The data import function/wizard isn't particularly omniscient. If you wish
to force all data coming from a given column in Excel into a compatible data
type column in Access, you could:
1. import the Excel data "as is"
2. "parse" the data from the (temporary) Import table into permanent
Access tables which you've created with the correct data types.

By this, I mean using the CInt(), CStr(), CDate(), and other converting
functions in queries against the Import table to explicitly type your data
and append the rows into your (permanent) table.

--
Regards

Jeff Boyce
<Office/Access MVP>

Sajit said:
When importing data from Excel to Access, even if the first few rows of data
in a field is text and then there is a number after this, this results in a
data type error and the wizard does not import.

The option of forcing all data to text appears dimmed. This provision should
be enabled.

Sajit Viswan

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
Click to expand...
http://www.microsoft.com/office/com...be9b2&dg=microsoft.public.access.externaldata
 
Yes, I would like to do that.
Unfortunately this shared excel file contents changes every day.
I have tried putting a macro in excel to keep the data type to either text
or number. But then the users of the excel file also wants to insert new
columns of data or rename existing ones.
 
Back
Top