Recent content by aj81

Here is the issue. I'd like to use a macro to display only those items which stay as a group in "Old Project Code" (black font) and filter out those which are singles in "Old Project Code" (red font) as shown below extracted out from a worksheet called "Project" in Excel. J K New_Project_Code...

Hope you learnt a lesson. Better not take own medicine next time.

Great! Life will become more peaceful.

Thanks Pat Hartman for your criticism. Things became clear at the end of discussion through the forum. I am learning everyday. At least those people tried to help. I appreciated for their genuine help. Where were you at the beginning of the discussion? When things become clear and conclusions...

The csv format was dictated by business (non-negotiable). Thanks guys for the thoughts which have made me more assertive. :)

Thanks for the help which makes me thinking. Firstly, pre-defining csv file didn't work. You could change "General Format" to "Text Format" for a column in spreadsheet, but you cannot save the file as the image in the attachment. It popped up an info box. Basicly it says: "features are...

Thank you all for the help, but it still didn't work. That's what I did. 1. Open up Access, click Text File in Import & Link group of External Data tab (as csv file is text file). 2. Import csv file from hard drive and save the file as "AB_Stock Import Specification" and data type as Text...

Appreciated for your reply. It worked fine with actual excel file (.xlsx), but same issue surfaced again when save it to .csv file which is required. Sure make "" or ' or Text format in the cell could retain the form. But you need to work out each field manually. In the case tens of thousands of...

In Access column name is STKITEMNBR and data type is TEXT. 4/5 of data are numeric and 1/5 are alfa-numeric. One of data was 15E10 in Access, but was altered to 1.50E+11 when exporting out to Excel csv file. Because it was Stock Item Number it needed to stay the same as 15E10 in csv file. Could...

I am a SQL developer but ofter from work I need to use Access which I have some knowledge and some questions. I am from Melbourne Australia. Cheers.