If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help changing a excel sheet to a access DB, NOT Linked
Hi ;
I could use a tip here. I need to convert a Excel spreadsheet, single page, 10 fields, approx 700 records into a MS Access standalone database... as if I had typed it in manually from scratch. This is first step of making a full blown inventory DB w/ maintenance records, updates, etc of company computers, instead of the simple chart it is now. I must be missing something, since my attempts continue to bring it in as a linked table, not what is needed. I have attempted to convert to a CSV, a TAB delimited, A DB file, etc. Access will read it, but continues to treat it as a linked table, apparently back to the original. We are using Access 2000, Excel 2000. Does anyone see something I am missing? Thanks... Greg |
#2
|
|||
|
|||
Need help changing a excel sheet to a access DB, NOT Linked
Greg
"Linked" means, well, linked. Instead of using "Link..." when you "Get External Data", try using "Import..." Note: if any of your Excel data is ambiguous (as to type), you'll get what Access decides to call it for field types. If this happens, you can still create your own table definition in Access, then do parsing queries from your imported/linked table into the one you defined. -- Good luck Jeff Boyce Access MVP |
#4
|
|||
|
|||
Need help changing a excel sheet to a access DB, NOT Linked
Thanks, Armen.
When I thought more about it, I realized Access doesn't have "parsing" queries! But I use queries to "parse"... g Jeff Boyce Access MVP "Armen Stein" wrote in message ... In article , -DISCARD_HYPHEN_TO_END says... Greg "Linked" means, well, linked. Instead of using "Link..." when you "Get External Data", try using "Import..." Note: if any of your Excel data is ambiguous (as to type), you'll get what Access decides to call it for field types. If this happens, you can still create your own table definition in Access, then do parsing queries from your imported/linked table into the one you defined. A minor clarification on Jeff's response: The "parsing" queries Jeff is referring to are actually Append queries in Access. These can be used to copy data from one table to another. -- Armen Stein Access 2003 VBA Programmer's Reference http://www.amazon.com/exec/obidos/AS...jstreettech-20 J Street Technology, Inc. Armen _@_ JStreetTech _._ com |
Thread Tools | |
Display Modes | |
|
|