more specific

[geechi]

cut and paste solves your problem

my problem is I'm not sure where I should begin.

AdoExcel to read it, then replace the database?
[support.microsoft.com...]

or this
[freevbcode.com...]

this one really confuses me
[experts.about.com...]

basically what is the PREFERRED method of doing this?

help some1...pls.
u can email me @ [e-mail] also
i probably just broke some forum rules i apolgize if so

[oxbaker]

ok so you've shown us three links with three different ideas about using data. Can you please maybe post a specific question so someone can help?

you got idea 1: writing data to an excel file via ADO. In some contextes, like exporting data this is a good idea, to store data this is a horrible idea,

then you have idea 2: using someone elses free vb code to write more data to an excel file, same reasoning as #1, they are probably the exact same thing just one person wrote it as opposed to you writing it,

then idea 3: using an Access MDB for a database, importing excel files to it.

So i dont even know what you want to do. What do you want to do?

General tips:

1. If your storing data from a site to a db you want to use SQL Server or MySQL or something worth a salt. Access bloats everything and excel is just a no-no.

2. If you have tonnes of data and want to import it i suggest creating a DTS Package and importing to a proper database, as MySQL and SQL Server both have very robust importing features that allow bulk imports.

hth,
mcm