Need help changing a excel sheet to a access DB, NOT Linked

[Greg]

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

 

[Jeff Boyce]

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.

 

[Armen Stein]

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/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com

 

[Jeff Boyce]

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>