Controling excel from access

[ronstar]

Hi Everyone,

I have .csv files which I need ot import into Access, but when imported directly some data is lost (even when I do the import manually).

When I first import the data from .csv to excel (2003), and only then to Access the data is not lost.

I have the part of importing from excel to access automated already.

I would like to automate the part of importing from .csv to excel as there are a lot of excel files and importing every one to excel manually and then saving it as an excel file is a lot of boring work.

Would really appreciate if someone could suggest how to control excel programatically from access so that I can import the csv files to excel, then save the file and close it.

Thank you
Ron

 

[vbaInet]

Can you give us examples of the records or data that get lost? Is there some pattern?

Do you use the Import & Export wizard to perform this operation?

 

[ronstar]

The record that gets lost is a date

in hte csv it appears as:
57:21.8 for example

it gets lost whether I import programatically or manually.

thanks

 

[vbaInet]

What is the data type of the field you are importing it into?

By the way, that is not a well formed date so it will get thrown out.

 

[ronstar]

I managed to fix the problem by changing the specs on the Import Specifications.

This allowed me to define how each field would be treated in the file being import

 

[vbaInet]

Glad to hear ronstar!