Database Excel Spreadsheet

  • Posted
  • Proposals 11
  • Remote
  • #18089
  • Expired
Nilesh P.Alison G.Guy V.Adam B.Harry A. + 6 others have already sent a proposal.
  • 1

Description

Experience Level: Intermediate
I run a small recruitment consultancy we have a candidate database running on ACT (a basic contact management system) We're migrating to another contact management system.

I've tried to export the data from ACT onto excel and i need some slight modifcations in excel in order for the same data to be correctly aligned into another excel import table

eg. data in one cell is
"Attachment: \\\\Server\\my documents\\CV's\\Manchester\\070509 Katie Abbott.doc"

What i require is partial text removal leaving only the file name "070509 Katie Abbott.doc" for the import field for the new database.

there are perhaps 5-6 fields to edit in a similar way
You can argue that these are not huge changes but detail in correctly importing this database of 4500 candidates contact details and correctly attached cv's is important.

what I can present is the full database file of this format (.dbf)
if possible can you export this to an excel spreadsheet

i'll also present an excel "import table" this shows all the fields i need filled in order to migrate into the new system

If you are interested in this job please place your bid.

Clarification Board

    There are no clarification messages.