Skinner
ADMIN
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Apr-15-04 04:16 PM
Original message |
Any Microsoft Access experts here? |
|
I'm a total Access moron (in fact, I'm a total database moron), and there is something I'm trying to do. In short: I'm trying to import a flat-text data file into a relational database with two tables.
If this is something you might be able to talk me through, please send me a private message. Thanks. :thumbsup:
|
BootinUp
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Apr-15-04 04:48 PM
Response to Original message |
1. The import wizard should walk you through it |
|
I program in Access, but I don't know the import wizard step by step. Maybe if you asked a more specific question I could help.
|
DontBlameMe
(889 posts)
Send PM |
Profile |
Ignore
|
Thu Apr-15-04 04:57 PM
Response to Original message |
2. What delimiters does it use? |
|
Tab, comma, etc. Also, does it have more than 256 fields?
|
prolesunited
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Apr-15-04 05:23 PM
Response to Original message |
3. Must be nice getting to pin YOUR |
|
requests to the top, like you're important or something. :P
JK, but wish I had a clue. Hope you get your problem resolved. :hi:
|
Commie Pinko Dirtbag
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Apr-15-04 05:27 PM
Response to Original message |
4. So, did the hocus pocus work? |
|
Or do I have to whip up some abracadabra too?
|
sangh0
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Apr-15-04 05:44 PM
Response to Original message |
|
First, I'm assuming the data you want to import is in a file named *.txt
Click on File!Get External Data!Import. A window for selecting the file will show up. Near the bottom of that window is a drop-down listbox labelled "Files of type". Click on that and select "Text files (*.txt, *.csv, *.tab, *.asc)", and then navigate to the directory where your text file is. Select your text file and click on the button labelled "Import"
The next window wants you to choose between delimited records or fixed-length records. Pick the delimited choice and click on Next.
The next window will ask you to choose the proper delimiter. Do that, and then that window will try to figure out where to break up the fields. It tends to do a good job at this, but you can review the results in the lower half of that window. If it looks right, click on Next.
The next window will let you name the new table that the data will be imported into. I suggest you import the whole text file into one table, and then write some queries to extract data from the new table and insert it into the other two tables.
|
Thew
(110 posts)
Send PM |
Profile |
Ignore
|
Thu Apr-15-04 06:26 PM
Response to Original message |
|
I ask because 97 and earlier may require you to run the set-up program and add data access options before you can import text files.
|
Skinner
ADMIN
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Apr-15-04 06:39 PM
Response to Original message |
|
I'll get back to you tomorrow if I need more help.
:thumbsup:
|
Blue-Jay
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Apr-15-04 06:42 PM
Response to Original message |
8. I find that shaking a chicken leg at the computer works |
|
Barring that, I just pretend that it's not very important.
|
Nlighten1
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Apr-15-04 06:46 PM
Response to Original message |
|
Is your monitor on?
:)
just kidding.
|
DU
AdBot (1000+ posts) |
Mon May 13th 2024, 03:59 AM
Response to Original message |