Find Jobs
Hire Freelancers

337569 Cnvrt Excel 2 local database

N/A

Käynnissä
Julkaistu lähes 15 vuotta sitten

N/A

Maksettu toimituksen yhteydessä
I have a table/sheet in Excel I need to import into a database so I can work with it more efficiently. IU will have a # of ongoing add'l tasks once this is done as I have a lot of work to do after that (integrate/compare/relate to other tables mostly). In a nutshell I have a main column which is set up as a hiearchy of data e.g Group1 Group1.1 Group 1.1.1 Group2 Group 2.1 Group 2.1.1 Group 2.1.2 Group 2.1.2.1 etc. except it was not #d as such, just done with indents. I have previously been able to get scripts that parse indents as levels so I know that can work. So the first step would be simply to pull into a table where I can collapse/expand levels so I can simply *see* my data better. I'd also like to easily be able to; 1) Add new data to any level and or change that level/indent/hierarchy easily 2) Move any given record up/down a level w or w/o it's children. Finally, because many records were supposed to belong to more then one hierarchy and I was using Excel, I made a column called 'Add' Parents' where I would simply name the add'l assignment e.g. Group 1.2.1 might be assigned to Group 4.2.1.1 (again I did not name like this i.e. #s) In a real db then that record would appear under both e.g Group 1.2 Group 1.2.1 Group 4.2.1.1 Group 1.2.1 I'd like there for tthat column do do just that, to retain the values (so I can remove the re-asignemnt if I want) but also to appear where re-assigned. There are a # of other columns which for now should simply travel with that record and keep their values which won't be used for anything until subsequent tasks. I can provide a sample of data if necessary, pretty straightforward though I just want to be able to work with what has become unwieldy (3,000 records, many indents, many add'l assignments) more easily and efficeintly, as i say more tasks to come.
Projektin tunnus (ID): 2083383

Tietoa projektista

Etäprojekti
Aktiivinen 12 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista

Tietoja asiakkaasta

Maan UNITED STATES lippu
New York, United States
5,0
10
Liittynyt kesäk. 7, 2010

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.