Importing everything from Excel file as text

  • Thread starter Thread starter mattieflo
  • Start date Start date
M

mattieflo

Hello,

I have 40 columns of information in excel that I want into an Access
database. I don't really to do anything with them, I just need to view the
corresponding information with a customer's name when I run queries.

Anyway, the 40 columns of data is made up percentages, dates, and regular
text. I'm trying to import them into a table that is completely text. I was
under the impression that as long as you import them as text, it would simply
import what was entered regardless of what kind of data type it is. When I
try to import it, I get the "Numeric Overflow" error. Does anyone know what
are some symptoms of this particular problem? It used to work, but all of a
sudden it quit working and Im not sure why.

Thanks.
 
mattieflo,
it sounds as if the import process thinks that some of the columns are
numbers, not text.
Go back to the spreadsheet and insert a blank row immediately under the
column headings.
In each column type xxxx.
The above will force the import process to think that each column contains
text.
This should allow you to import all the info to text fields in the access
table.
When the import is finished, you can open the table and delete the row where
all the fields are xxxx.


Jeanette Cunningham -- Melbourne Victoria Australia
 
Back
Top