Find Jobs
Hire Freelancers

convert a MS Access table from mostly columns to mostly rows

$30-250 USD

Terminado
Publicado hace más de 6 años

$30-250 USD

Pagado a la entrega
We have a Microsoft Access (2007) table that has perhaps 50 columns, and ~1500 rows of information. But I would like to convert (and move the underlying data) most of the columns to rows. Much of the column information repeats to some extent. I would like someone to write what I'm guessing is some simple code to do a 1-time conversion of the table. The table has confidential information that I will not be providing, but I can do a mock-up of the table with some fake column headings, and would ask you to write and provide the code to me (and instructions) so I could execute it for the conversion.
ID del proyecto: 15474634

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hello. First I will work with your dummy data, create the necessary code, test it on sample access database then deliver you the code. You will be able to run it on your database. Relevant Skills and Experience Access, Excel, VBA Proposed Milestones $155 USD - Will be paid when job is done and customer is 100% satisfied I'm mostly available if you wanna discuss further. Thanks.
$155 USD en 5 días
5,0 (87 comentarios)
6,9
6,9
7 freelancers están ofertando un promedio de $180 USD por este trabajo
Avatar del usuario
Hi! What we need here is a code that will load data from the table and write to new data. This is called "transposing data". It will help if you can send a mockup, with just a few rows of dummy data. Relevant Skills and Experience MS Access professional developer for 24 years, MS Access MVP 2008 and 2009 Proposed Milestones $164 USD - Completed project If you need help creating mockup, let me know! Thanks!
$164 USD en 3 días
5,0 (256 comentarios)
7,6
7,6
Avatar del usuario
As an expert in ms access related works, i am very much interested to do this work. Looking forward to have a positive response from you. Thanks Relevant Skills and Experience vba Proposed Milestones $80 USD - Initial $80 USD - Final Can you please send me the similar database with some same data and expected output?
$150 USD en 2 días
5,0 (186 comentarios)
7,2
7,2
Avatar del usuario
Hi there, Without seeing the data or the table itself it's difficult to tell whether an SQL or a VBA script would me more sufficient solution to transpose your data, but I will propose the better one Relevant Skills and Experience I have been working as a data analyst with VBA and SQL skills for 4 years. Proposed Milestones $175 USD - Completion
$175 USD en 2 días
5,0 (96 comentarios)
6,6
6,6
Avatar del usuario
I read your requirements, We have a Microsoft Access (2007) table that has perhaps 50 columns, and ~1500 rows of information. But I would like to convert (and move the underlying data) most of the columns to rows. Much of the column information repeats to some extent. I would like someone to write what I'm guessing is some simple code to do a 1-time conversion of the table. The table has confidential information that I will not be providing, but I can do a mock-up of the table with some fake column headings, and would ask you to write and provide the code to me (and instructions) so I could execute it for the conversion. Please open PM for discussion. Ponsi
$264 USD en 3 días
5,0 (131 comentarios)
6,6
6,6
Avatar del usuario
Hi, I can create a macro to convert table data into new table according to specific condition. No matter how many records are there. Macro will detect rows and column numbers. Relevant Skills and Experience Experienced Data Analyst and Macro Developer. I have excellent knowledge and experience of Manipulating Data of Access tables through vba programming. So, can do this job nicely. Stay tuned, I'm still working on this proposal.
$175 USD en 3 días
4,8 (78 comentarios)
5,6
5,6
Avatar del usuario
Dear sir, I can implement a converter in JAVA. Would like to discuss.. Thanks Relevant Skills and Experience I have implemented Derby to MySQL convertor before.. Proposed Milestones $175 USD - Milestone
$175 USD en 3 días
4,9 (26 comentarios)
4,1
4,1

Sobre este cliente

Bandera de UNITED STATES
Poughkeepsie, United States
5,0
3
Forma de pago verificada
Miembro desde oct 24, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.