• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1361
  • Last Modified:

subscript out of range when importing from excel

Any idea about this message that i get when trying to import data from excel to ms access, same fields, sames types.
0
titorober23
Asked:
titorober23
  • 2
  • 2
1 Solution
 
Patrick MatthewsCommented:
Hello titorober23,

Are you running code?  If so, what is it, and what line does the debugger jump to?

Regards,

Patrick
0
 
titorober23Author Commented:
no just basic import window, i select the table and choose import select the file, everything goes finf till i click finish i tjust said "subscript out of range"
0
 
titorober23Author Commented:
I just check the date fields, and select the same format as ms access and then works smooth
0
 
harfangCommented:
This could be caused by invalid characters in the sheet name, for example. Microsoft doesn't always agree with Microsoft when it comes to that... Can you try it with a workbook called "Book1", from a sheet called "Sheet1" (and, while we are at it, to a table called "Table1")?

(°v°)
0
 
harfangCommented:
Sorry, missed your last post. You solved it, then? -- (°v°)
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now