Normalize your spreadsheet data Easily.

Status
Not open for further replies.
Uncle Gizmo

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 02:34
Joined
Jul 9, 2003
Messages
16,850
The following links contain instructions, plus a database containing a transposition tool (a Form) to extract information from a flat file Database, (something like a spreadsheet) into a structure more suitable to take advantage of MS Access relational properties.

Excel in Access (Part 1)
Excel in Access (Part 2)
Excel in Access (Part 3)
How to use the Normalization Form

Download the Latest database containing the Form and instructional tables here:
 
Status
Not open for further replies.

Similar threads

H
How to insert some data from Excel spreadsheet and the other data from Access combo boxes
Replies
6
Views
255
Pat Hartman
P
arnelgp
Json file to Access table/tables
Replies
0
Views
702
arnelgp
arnelgp
Rodeo Clown
Access import function converts text field to scientific notation
Replies
9
Views
358
cheekybuddha
cheekybuddha
Uncle Gizmo
Use AI to Resurrect your shelved Project
Replies
5
Views
257
Uncle Gizmo
Uncle Gizmo
Gasman
Solved Normalisation
Replies
1
Views
158
DickyP
DickyP

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom