RE: Importing files from Excel

From: Carol W (anonymous_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 08:00:47 -0700

But I am using Access 2002. I was also using A-2002 on
my last computer, but didn't have this problem. The only
difference on the new computer is that my version of
Outlook is 2003, but Access is still 2002. Btw, it works
fine when importing from a text file; but the problem is
only when importing from Excel.
>-----Original Message-----
>Hi @ all,
>
>Ed,
>This is a bug in Access 2003 and there is no fix yet
available. Import your file in a table in Access and
format, name the fields / columns as needed. For the
future import your file to an other table and use an
append query to paste your data into the formated table.
>
>Jerry, Carol,
>Access checks the first 15 rows and decides on the data
found there the data type (Text, number, etc.). So in
case you want different data types try amending your .xls
file. Add e.g. an additional line with dummy data or try
what i have suggest above.
>--
>HTH
>Bernd
>
>
>
>"EHamdan" wrote:
>
>> I am having the exact same problem. The only thing is
that
>> I can't change the data-type or name of the field.
Mind
>> you I can change these from the Advanced window but my
>> clients are complaining about the main "Import Text
>> Wizard". It says in the instructions that if you click
the
>> field you can rename it etc but that doesn't seem to
work.
>> I have access 2003 and winXP SP1. Is there something
wrong
>> with access or is there a setting that needs to be
toggled?
>> or patched?
>> Thank you very much.
>>
>> EHamdan
>>
>> >-----Original Message-----
>> >
>> >If you want to change the column name,
>> >it can be done in the next step of the wizard.
>> >
>> >If you want to change the data-type of the column,
>> >sorry, not possible, Access does that for you.
>> >
>> >Regards,
>> >JohnQ
>> >
>> >>-----Original Message-----
>> >>From Access I select "FILE" then "Get External Data"
>> then
>> >>I choose "Import". After selecting an .XLS file I go
to
>> >>the "Import Spread*** Wizard". On the page where
you
>> >>can specify information about each of the fields you
are
>> >>importing it dosn't seem to matter which column I
click
>> >>on the "Field Name" textbox remains with the first
>> column
>> >>name. Without being able to change the column that I
am
>> >>on I can't alter the fields. Is this a bug that has
a
>> fix
>> >>out there that I have missed? I have downloaded
every
>> >>update that I could find in order to fix this. I am
>> using
>> >>Office 2002 on windows XP Professional platform. I
have
>> >>also loaded the SP3 update for Office and SP1 for
XP.
>> >>Thank you.

Loading