Reusable Data Import Wizard

[sudarshan1413]

Hello Friends ,

I have one scenario.

Daily I paste thousands of rows in excel for analysis.

These all rows are in delimited(^) format.

So every time , I need to go to data import wizard and use delimeter(^) to import the data into excel.

When I am importing data into excel, I have one more thing to do i.e. to make every column as text , becuase i dont want to miss any value.


Can above scenario be made reusable , with macro or any other workaround for the same?


Thanks in advance!


Sudarshan

 

[Hui]

Sudarshan


Firstly, Welcome to the Chandoo.org Forums


Have you tried recording a macro to do the importing?


Using a macro will enable you to automate the task and save you loads of time.


The easiest way to record a macro is to enable VBA

goto File, Options, Customize Ribbon

Enable the Developer Tab in the Right Pane


In Excel click on the Developer Tab

Record Macro

carry out your import/reformat


click on the Developer Tab

Stop Recording


You can now use the code in VBA as a base for setting up an import macro to do it repeatedly


Try that out and come back with some more questions

 

[sudarshan1413]

Hi Hui,


Thanks a lot for your response.


I have tried Excel macro but with that I am able to automate only importing for some delimiter.


In Excel macro , is it also possible to automate importing all the columns in text , which we do in data import wizard?


Because for each file no of columns will be different , right ?


So how to handle that through macro..?


Thanks

Sudarshan

 

[Hui]

Sudarshan


Can you post a sample file with a sample input and a processed sheet so we can see what it should look like after processing


Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook