Dear All EPFO Gurgaon Required CD formate for submitting EPF return So How it possible from exel can any body help me
From India, New Delhi
36From India, New Delhi
I am not sure but my suggestion is 'you can write the file in CD and submit it'. Now-a-days everything is converted in soft copy for maintaining records which is cost effective. The entries should be made by EPF employees but they pour on us by making their work so simple...
From India, Madras
From India, Madras
EPFO Gurgaon Required CD formate in dbf file submitting EPF return it possible to convert from exel to dbf file.
From India, Gurgaon
From India, Gurgaon
Check out the following utility to Convert xls to dbf
Import from XLS / XLSX (Excel) to DBF Base
This dialog window imports data from an Excel file. With "Import data into current (opened) database file" option, the DBFView will insert records from xls / xlsx file you selected into current dbf file. In this case the number of fields and field types should be the same as opened dbase file. If "Import data into another DBF file" is checked, the program will create a new dbf file based on selected Excel xls / xlsx file.
[img]http://www.dbfview.com/img/import_from_xls.gif[/img]
When you export .xls files you should take into consideration some limitations:
1. Rules of the columns names.
- Columns names should be written down one after another (beginning with the cell A1).
- Empty names of the columns are not supported (columns laying to the left are only imported).
- Columns names longer than 8 symbols are truncated up to 8 symbols.
2. Rules of the columns type definition.
The columns type is defined according to the type of the data entered into the second row, i.e. if the integer value is written in the second row that column will be of the integer type.
From India, Lucknow
Import from XLS / XLSX (Excel) to DBF Base
This dialog window imports data from an Excel file. With "Import data into current (opened) database file" option, the DBFView will insert records from xls / xlsx file you selected into current dbf file. In this case the number of fields and field types should be the same as opened dbase file. If "Import data into another DBF file" is checked, the program will create a new dbf file based on selected Excel xls / xlsx file.
[img]http://www.dbfview.com/img/import_from_xls.gif[/img]
When you export .xls files you should take into consideration some limitations:
1. Rules of the columns names.
- Columns names should be written down one after another (beginning with the cell A1).
- Empty names of the columns are not supported (columns laying to the left are only imported).
- Columns names longer than 8 symbols are truncated up to 8 symbols.
2. Rules of the columns type definition.
The columns type is defined according to the type of the data entered into the second row, i.e. if the integer value is written in the second row that column will be of the integer type.
From India, Lucknow
Hai.............................................................................................
From India, Pune
From India, Pune
Dear Mr. Santosh, You are hereby advise to perpare the PF return in xls format and save the file in dbf with option save as. if requred xls format you may ask for it. Regards Tirlok Dhir 9872072450.
From India, Gurgaon
From India, Gurgaon
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
New ABP return for PF 20.1.10.pdf
PF CD FORMAT.xls