Advertisement

04.21.2008 at 01:46PM PDT, ID: 23341025
[x]
Attachment Details

Import Large Excel File into Access (Numeric Field Overflow Error)

Asked by MistahMilla in Microsoft Access Database, Microsoft Excel Spreadsheet Software

Tags: , , , ,

Hi,

I'm trying to import a very large (50 thousand+ rows, 65+ columns) Excel spreadsheet into Access. I keep getting the "Numeric Field Overflow" error. Every field in the table that i'm importing into are large text fields. I think the error is because some of the columns have numbers in the first 10 or so rows so excel assumes its a number and freaks out when it finds an entry with a letter in it thousands of rows down.

What is the easiest way to get around this error? I have tried putting a character infront of everything in the first 10 rows of every column so that excel will think it is all text but that did not work. I do not want to link in the excel file, currently i am having the user select the excel file with the filedialog and then using the transferspreadsheet function to load in the data.

Any suggestions would be greatly appreciated.

Thanks.Start Free Trial
[+][-]04.21.2008 at 02:35PM PDT, ID: 21406285

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.21.2008 at 02:44PM PDT, ID: 21406350

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, Microsoft Excel Spreadsheet Software
Tags: Microsoft, MS Access, 2003, Importing data from Excel, Numeric Field Overflow
Sign Up Now!
Solution Provided By: jeffld
Participating Experts: 2
Solution Grade: B
 
 
[+][-]04.21.2008 at 04:46PM PDT, ID: 21407116

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.21.2008 at 07:05PM PDT, ID: 21407699

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.22.2008 at 06:58AM PDT, ID: 21411126

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628