Importing Excel Table

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
 
A

Alex Dybenko

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
 
O

Oded Kovach

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?
 
A

Alex Dybenko

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
 
T

Tony Wainwright

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
 
A

Alex Dybenko

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
 
Top