Import Data

[chad_needs_help]

Need help!

I have an Excel spreadsheet for a mail list. I want to import it into Excel.
Unfortuanatly, it is formated without a header row. Instead, the data for
each record is identified in column A with the corresponding data in Column B
per example below:

Company ABC
Member Type Designer
Name Bob Smith
Address 601 Main Suite 112 Anytown, NC 22222
Directions Click Here to Get Driving Directions
Phone (555) 555-1212
Fax (555) 555-1213
E-Mail (e-mail address removed)
Website www.abc.COM
Distance 0.08 miles

Is there a way to map the cells to an access database to import this
information?

Thanks!

 

[Tom Wickerath]

Hi Chad,

I have an Excel spreadsheet for a mail list. I want to import it into Excel.

I assume you meant that you want to import it into Access, since it's
already in Excel?

Is there a way to map the cells to an access database to import this information?

Not directly as far as I know. However, you can export the data to a text
file, and then use a custom import routine written in VBA code to import the
data. A bit more information would be helpful. For example, are the
identifiers in column A repeated in rows for the next contact, or is
additional contact information listed in columns C, D, E, F, etc.


Tom
_________________________________________

:

Need help!

I have an Excel spreadsheet for a mail list. I want to import it into Excel.
Unfortuanatly, it is formated without a header row. Instead, the data for
each record is identified in column A with the corresponding data in Column B
per example below:

Company ABC
Member Type Designer
Name Bob Smith
Address 601 Main Suite 112 Anytown, NC 22222
Directions Click Here to Get Driving Directions
Phone (555) 555-1212
Fax (555) 555-1213
E-Mail (e-mail address removed)
Website www.abc.COM
Distance 0.08 miles

Is there a way to map the cells to an access database to import this
information?

Thanks!

 

[Mike Painter]

Need help!

I have an Excel spreadsheet for a mail list. I want to import it into
Excel. Unfortuanatly, it is formated without a header row. Instead,
the data for each record is identified in column A with the
corresponding data in Column B per example below:

Company ABC
Member Type Designer
Name Bob Smith
Address 601 Main Suite 112 Anytown, NC 22222
Directions Click Here to Get Driving Directions
Phone (555) 555-1212
Fax (555) 555-1213
E-Mail (e-mail address removed)
Website www.abc.COM
Distance 0.08 miles

Is there a way to map the cells to an access database to import this
information?

Thanks!

You can't map them and may have to use code.
You could export to Word and use search and replace to convert to a flat
file, then import into Access. I just wrote this up less than a week ago so
a Google might find the explanation.
This is the quickest way if it's a one-shot deal.

Writing code to loop through the records is not hard but time consuming.

 

[Patcharavut]

Need help!

I have an Excel spreadsheet for a mail list. I want to import it into Excel.
Unfortuanatly, it is formated without a header row. Instead, the data for
each record is identified in column A with the corresponding data in Column B
per example below:

Company ABC
Member Type Designer
Name Bob Smith
Address 601 Main Suite 112 Anytown, NC 22222
Directions Click Here to Get Driving Directions
Phone (555) 555-1212
Fax (555) 555-1213
E-Mail (e-mail address removed)
Website www.abc.COM
Distance 0.08 miles

Is there a way to map the cells to an access database to import this
information?

Thanks!