| n00bfest http://n00bfest.com/phpBB3/ |
|
| Anybody here good with Access and macros and shit? http://n00bfest.com/phpBB3/viewtopic.php?f=11&t=42650 |
Page 1 of 1 |
| Author: | the_yeti [ Thu Oct 20, 2011 3:44 pm ] |
| Post subject: | Anybody here good with Access and macros and shit? |
Ok, here's what I'm trying to do. We have an Access program for filling out a form we have. It works great, but before this, we had a Excel spreadsheet to log the information contained on this form. There's a handful of fields, like report #, requester, project engineer, part # and so on. SO, to get our nifty Access program up to date, I've been stuck with the task of hand-importing all the data from the cells in Excel to the table in Access. And there's THOUSANDS of rows worth of report data. so Is there a cool, techy, macro, VB way (I know nothing of macros, coding, VB, w/e) to auto-import the Excel data into the Access table? Thanks. |
|
| Author: | Gman [ Thu Oct 20, 2011 4:32 pm ] |
| Post subject: | Re: Anybody here good with Access and macros and shit? |
Fomenta can probably whip something up. |
|
| Author: | the_yeti [ Thu Oct 20, 2011 8:06 pm ] |
| Post subject: | Re: Anybody here good with Access and macros and shit? |
Word.. but don't feel obligated. I feel kinda stupid. Like as if this is bottom-rung shit for a programmer like 'menta, but it's just shit I've never done before nor was I ever taught, lol. Full credit will be given where it is due, also. I aint no stooge. |
|
| Author: | fomenta [ Thu Oct 20, 2011 8:42 pm ] |
| Post subject: | Re: Anybody here good with Access and macros and shit? |
This can definitely be done. I just taught a course on Excel and Access actually. If you wanna send me like trimmed down versions (like, 4-5 example entries) of the before excel, before access and after access files, I can whip something up np. If not, screenshots and some description might work. |
|
| Author: | Cpt. Carrot [ Thu Oct 20, 2011 10:16 pm ] |
| Post subject: | Re: Anybody here good with Access and macros and shit? |
Try the import via the External Data option Attachment: step1.jpg [ 49.53 KiB | Viewed 3250 times ] Attachment: step2.jpg [ 100.45 KiB | Viewed 3250 times ] Attachment: step3.jpg [ 83.78 KiB | Viewed 3250 times ] Go through to import wizard, and then (if necessary) use some queries to manipulate the data to get what you need. big lulz, 'cause my wife told about the "External Data" thing |
|
| Author: | Falcon [ Fri Oct 21, 2011 10:09 am ] |
| Post subject: | Re: Anybody here good with Access and macros and shit? |
lol, im with carrot. back in school we had to write a Vb script to to this exact thing, worked on it for 3 days cause I had no idea what I was doing. then I realized you can just import the excel documents using the wizard carrot posted. it worked like a charm |
|
| Author: | the_yeti [ Fri Oct 21, 2011 10:50 am ] |
| Post subject: | Re: Anybody here good with Access and macros and shit? |
I was told by my boss, the creator of this Access program, that this wouldn't work as there are multiple tables linked to a SQL database and subsequently linked to each other in various ways. I don't know how the F*CK it works... |
|
| Author: | Cpt. Carrot [ Fri Oct 21, 2011 12:44 pm ] |
| Post subject: | Re: Anybody here good with Access and macros and shit? |
what about importing data from excel to the temp tables using the method I showed and then running import / append queries to get the data populated in the production table? |
|
| Page 1 of 1 | All times are UTC - 6 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|