Missing columns by getting External data

[Roncancio]

Hello,

A co-worker tries to get csv-files into an existing database.
She does this by:
- [tab] External data
- Import Text File
- Browse (to csv-file)
- Append a copy of the records to the table ...
- OK
- Advanced.

She should have 4 columns (Should be.jpg) but she only sees 2: (Missing columns.jpg).
She works with Access 2010 and in Access 2003 it works fine.

- Why can't she see those columns?
- How can she see those 2 columns?


- Did I miss something in order to get those missing columns?

Thanks in advance for any help.

Kind Regards,



Roncancio

[June7]

Want to provide example csv for testing? Attach to post, zip if large.

[Roncancio]

Dear June7,

Thanks for your reply.
I have added an example csv-file.
The original file contains almost 200,000 records.

Kinds Regards,


Roncancio

[June7]

No problem importing all fields with Access import wizard. You appear to be using a custom VBA procedure to accomplish this. I would have to analyze that procedure code.

[Roncancio]

I'm afraid I don't quite understand what you mean.
The testfile I added is a csv-file with data that should be added to an existing table.
Both the table and the csv-file contains the same format.

In short: the table is like a collection of multiple testfiles, but then larger.

Kind Regards,


Roncancio

[June7]

I used Access import wizard to import the csv into a table in Access. All data came in. The interface you show in the images looks like an Access form someone built for this purpose, at least I have never seen anything like it. It would have VBA code procedure performing the import. I would have to analyze that code.

[Roncancio]

Thanks for your reply.
It is not a userform nor does it contains VBA-code.
The menu can be seen with the steps I wrote in my question #1.

Kinds Regards,


Roncancio

[June7]

Sorry, missed the 'Advanced' step. Never used it before. Only thing I can suggest is that MS decided it was unnecessary to show those field properties because they weren't relevant to deciding which fields to include and can't be changed by the import procedure.

[Roncancio]

Solved!!
By importing csv-file the database got corrupted.
For example, a columns contains both "CAN" and CAN.

My co-worker says to me that she uses csv-files because Excel is too small.
Actually Excel wás too small because she recently migrated from 2003 to 2010.
By saving the csv-file as an Excel 2010 file, the data could be imported correctly.

Thanks June7 for your time and help.
It is highly appreciated.

Kind Regards,


Roncancio

[June7]

By solved do you mean that those missing field properties are displayed in the dialog or just that the data imports properly? The sample data you sent does not show any values as "CAN" only CAN so my import test had no problem.

[Roncancio]

With solved I mean that the data is imported correctly.
The sample I sent was just an example of the layout of the file with fictitious data. Only the headers were original and I wrote the "CAN", CAN as an indication of what was shown in the database.
In the original database we did receive a kind of "CAN" and CAN in 1 column. Many records had this problem.
My co-worker did not realise Excel 2010 has far more records than Excel 2003.

I hope I clarified the situation.

Kind Regards,


Roncancio