Importing Excel Table

  • Thread starter Thread starter Oded Kovach
  • Start date Start date
O

Oded Kovach

Hello there

I have small program that inport excel datasheets to access table and work
with them.

One of my clients send me .csv files which can't be read by import data from
excel

How can i import these files?

any help would be useful
 
you can try to import this file as text, comma separated. try to run import
wizard, it will help you to find correct import specification
 
Thanks Alex.

When i've tried using it by the wizart i've chosed to recive it as text. But
it gave an error of Overflow

What can i do to import this file?
 
Well, probably you have to check what is wrong with it - try to open it in
notepad and see what is wrong there. try to post few lines here
 
I am currently experiencing a similar problem except I have found that the
problem is when the value it is importing is not the same as access is
expecting i.e. #NUM! errors (it found text when expecting a number or vice
versa). The spreadsheet I'm importing has 24,000 rows with 35 columns and a
lot of these contain mixed data types. If anyone has any ideas on how to
solve this...greatly appreciated

Tony
 
Hi
just an idea - you can try to add first line (one more) where you fill mixed
data columns with some text, so access can assume that this is text column
 
Back
Top