I am in the process of importing excel into Access and I keep getting this
message that states subscript is out of range.

This message is a "generic" one that indicates that the argument being
supplied to a subroutine or function is "out of the range" that the function
or subroutine expects or that it can find (e.g., suppose you have one form
open, and your programming tells ACCESS to open the second form in the
collection -- because there is no second form, you'd get this error
message).

You don't say how you're importing the file -- are you using File | Get
External Data | Import menu? Or are you using a macro (TransferSpreadsheet
action)? or VBA code (DoCmd.TransferSpreadsheet method)?

--

Ken Snell
<MS ACCESS MVP>


"Shargory" <(E-Mail Removed)> wrote in message
news:3922D5EE-66AD-40F3-9C5D-(E-Mail Removed)...
>I am in the process of importing excel into Access and I keep getting this
> message that states subscript is out of range.

I am actually transferring a excel worksheet file into access. I tranferred
3 worksheet from the same workbook but the 2 are giving me the subscript is
out of range.

"Ken Snell (MVP)" wrote:

> This message is a "generic" one that indicates that the argument being
> supplied to a subroutine or function is "out of the range" that the function
> or subroutine expects or that it can find (e.g., suppose you have one form
> open, and your programming tells ACCESS to open the second form in the
> collection -- because there is no second form, you'd get this error
> message).
>
> You don't say how you're importing the file -- are you using File | Get
> External Data | Import menu? Or are you using a macro (TransferSpreadsheet
> action)? or VBA code (DoCmd.TransferSpreadsheet method)?
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
> "Shargory" <(E-Mail Removed)> wrote in message
> news:3922D5EE-66AD-40F3-9C5D-(E-Mail Removed)...
> >I am in the process of importing excel into Access and I keep getting this
> > message that states subscript is out of range.
>
>
>

I am actually importing an excel worksheet into access. I have imported 3
worksheet from the same workbook so far but have been getting this message
with the two of them.

"Ken Snell (MVP)" wrote:

> This message is a "generic" one that indicates that the argument being
> supplied to a subroutine or function is "out of the range" that the function
> or subroutine expects or that it can find (e.g., suppose you have one form
> open, and your programming tells ACCESS to open the second form in the
> collection -- because there is no second form, you'd get this error
> message).
>
> You don't say how you're importing the file -- are you using File | Get
> External Data | Import menu? Or are you using a macro (TransferSpreadsheet
> action)? or VBA code (DoCmd.TransferSpreadsheet method)?
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
> "Shargory" <(E-Mail Removed)> wrote in message
> news:3922D5EE-66AD-40F3-9C5D-(E-Mail Removed)...
> >I am in the process of importing excel into Access and I keep getting this
> > message that states subscript is out of range.
>
>
>

I am importing from access External data.

"Ken Snell (MVP)" wrote:

> This message is a "generic" one that indicates that the argument being
> supplied to a subroutine or function is "out of the range" that the function
> or subroutine expects or that it can find (e.g., suppose you have one form
> open, and your programming tells ACCESS to open the second form in the
> collection -- because there is no second form, you'd get this error
> message).
>
> You don't say how you're importing the file -- are you using File | Get
> External Data | Import menu? Or are you using a macro (TransferSpreadsheet
> action)? or VBA code (DoCmd.TransferSpreadsheet method)?
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
> "Shargory" <(E-Mail Removed)> wrote in message
> news:3922D5EE-66AD-40F3-9C5D-(E-Mail Removed)...
> >I am in the process of importing excel into Access and I keep getting this
> > message that states subscript is out of range.
>
>
>

What is the path and filename for the EXCEL file? What is the name of the
worksheets in that file that are not importing?

--

Ken Snell
<MS ACCESS MVP>


"Shargory" <(E-Mail Removed)> wrote in message
news:2EA1487E-7C18-4FF8-B8F0-(E-Mail Removed)...
>I am actually importing an excel worksheet into access. I have imported 3
> worksheet from the same workbook so far but have been getting this message
> with the two of them.
>
> "Ken Snell (MVP)" wrote:
>
>> This message is a "generic" one that indicates that the argument being
>> supplied to a subroutine or function is "out of the range" that the
>> function
>> or subroutine expects or that it can find (e.g., suppose you have one
>> form
>> open, and your programming tells ACCESS to open the second form in the
>> collection -- because there is no second form, you'd get this error
>> message).
>>
>> You don't say how you're importing the file -- are you using File | Get
>> External Data | Import menu? Or are you using a macro
>> (TransferSpreadsheet
>> action)? or VBA code (DoCmd.TransferSpreadsheet method)?
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>>
>> "Shargory" <(E-Mail Removed)> wrote in message
>> news:3922D5EE-66AD-40F3-9C5D-(E-Mail Removed)...
>> >I am in the process of importing excel into Access and I keep getting
>> >this
>> > message that states subscript is out of range.
>>
>>
>>

Are you importing a named range in the spreadsheet? If the named range
includes blanks you can get this. Pete D.
"Shargory" <(E-Mail Removed)> wrote in message
news:AF2F3233-FB58-49A4-8457-(E-Mail Removed)...
>I am importing from access External data.
>
> "Ken Snell (MVP)" wrote:
>
>> This message is a "generic" one that indicates that the argument being
>> supplied to a subroutine or function is "out of the range" that the
>> function
>> or subroutine expects or that it can find (e.g., suppose you have one
>> form
>> open, and your programming tells ACCESS to open the second form in the
>> collection -- because there is no second form, you'd get this error
>> message).
>>
>> You don't say how you're importing the file -- are you using File | Get
>> External Data | Import menu? Or are you using a macro
>> (TransferSpreadsheet
>> action)? or VBA code (DoCmd.TransferSpreadsheet method)?
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>>
>> "Shargory" <(E-Mail Removed)> wrote in message
>> news:3922D5EE-66AD-40F3-9C5D-(E-Mail Removed)...
>> >I am in the process of importing excel into Access and I keep getting
>> >this
>> > message that states subscript is out of range.
>>
>>
>>

i do experience for "subscript out of range", when importing Excel to Access.
in my case, i did the followings:
1. the Field name should be the same as in both Excel and Access.
2. for the ID (Autonumber in Access) should be filled manual in Excel also.
3. Cell format both in Access and Excel should be the same.
HTH.

"Shargory" wrote:

> I am importing from access External data.
>
> "Ken Snell (MVP)" wrote:
>
> > This message is a "generic" one that indicates that the argument being
> > supplied to a subroutine or function is "out of the range" that the function
> > or subroutine expects or that it can find (e.g., suppose you have one form
> > open, and your programming tells ACCESS to open the second form in the
> > collection -- because there is no second form, you'd get this error
> > message).
> >
> > You don't say how you're importing the file -- are you using File | Get
> > External Data | Import menu? Or are you using a macro (TransferSpreadsheet
> > action)? or VBA code (DoCmd.TransferSpreadsheet method)?
> >
> > --
> >
> > Ken Snell
> > <MS ACCESS MVP>
> >
> >
> > "Shargory" <(E-Mail Removed)> wrote in message
> > news:3922D5EE-66AD-40F3-9C5D-(E-Mail Removed)...
> > >I am in the process of importing excel into Access and I keep getting this
> > > message that states subscript is out of range.
> >
> >
> >

jhhkhhkhk
"Andri" <(E-Mail Removed)> wrote in message
news:A8C10A41-CBFB-4852-8420-(E-Mail Removed)...
> i do experience for "subscript out of range", when importing Excel to
Access.
> in my case, i did the followings:
> 1. the Field name should be the same as in both Excel and Access.
> 2. for the ID (Autonumber in Access) should be filled manual in Excel
also.
> 3. Cell format both in Access and Excel should be the same.
> HTH.
>
> "Shargory" wrote:
>
> > I am importing from access External data.
> >
> > "Ken Snell (MVP)" wrote:
> >
> > > This message is a "generic" one that indicates that the argument being
> > > supplied to a subroutine or function is "out of the range" that the
function
> > > or subroutine expects or that it can find (e.g., suppose you have one
form
> > > open, and your programming tells ACCESS to open the second form in the
> > > collection -- because there is no second form, you'd get this error
> > > message).
> > >
> > > You don't say how you're importing the file -- are you using File |
Get
> > > External Data | Import menu? Or are you using a macro
(TransferSpreadsheet
> > > action)? or VBA code (DoCmd.TransferSpreadsheet method)?
> > >
> > > --
> > >
> > > Ken Snell
> > > <MS ACCESS MVP>
> > >
> > >
> > > "Shargory" <(E-Mail Removed)> wrote in message
> > > news:3922D5EE-66AD-40F3-9C5D-(E-Mail Removed)...
> > > >I am in the process of importing excel into Access and I keep getting
this
> > > > message that states subscript is out of range.
> > >
> > >
> > >