Import CSV

[sanju2323]

dear friends,
i am trying to import csv in excel as required column (cells). Please find the attachment file.
sorry for my bad english

[jindon]

What is "RL" Col.E in the result?

[MrShorty]

You have posted an .xlsm file in the VBA forum, suggesting to me that you are expecting a VBA solution. I would first ask -> are you required by some other constraint to use VBA for this? My inclination would be to use Excel's built in "Import External Data from text" command. Your profile says you are using 2003, and I don't remember exactly where that command was found in the menu system. If memory serves, it is in Data->Import External Data->Import from text. (If your profile is wrong and you are using a newer version of Excel, this help file should describe the command https://support.office.com/en-us/art...b-339e391393ba ).

Once you click on the command button, Excel should bring up a file selector window, select the file which should bring up the text import wizard. Work through the wizard selecting the desired options (which can include ignoring certain columns, since your example does not show importing all columns). At the end, choose the desired data range properties and you are done.

If this is a task that needs doing frequently, be sure to save the query definition, then future imports will be simple refresh operations.

[Kenneth Hobson]

If this is a one time thing, then manual imports as detailed would be best. If many, then a recorded macro would give you something to work with and easily modified.

For kicks, here is an ADO method. I doubt it will suit your needs since you are not importing all of the fields.

Please Login or Register  to view this content.

[sanju2323]

Hi Jindon, RL and ELEVATION both are same.

[sanju2323]

Hello Kenneth Hobson, Thanks for answering, but I am trying to use this code, but it is not working.

[jindon]

I think the suggestion from MrShorty is good enough though...

Please Login or Register  to view this content.

[CaptMac]

Downloaded your 2 files. Both the same.

Re Code, in looking at "Required Format.xlsm",
when I look at it in Excel there is no code that shows up
in the VBA module with it.
Did you forget to include it?

Mac