K
Karen
Ken,
If the information you copy from the website is always in
the same format, then I suggest you copy and paste it
into an "interim" or "conversion" spreadsheet. From
there, you can set up a sheet in the interim file which
puts the data into the same structure/format as your
Excel database. Then you can simply copy and paste it
from there into the database.
I do this all the time for clients who pull data from
various external sources. It comes in a mess and goes
out nice and clean to the database.
Karen
If the information you copy from the website is always in
the same format, then I suggest you copy and paste it
into an "interim" or "conversion" spreadsheet. From
there, you can set up a sheet in the interim file which
puts the data into the same structure/format as your
Excel database. Then you can simply copy and paste it
from there into the database.
I do this all the time for clients who pull data from
various external sources. It comes in a mess and goes
out nice and clean to the database.
Karen