I have a linked table that has source from an Excel sheet.

I now want it to be converted into normal data table.

How ?

Hi Mr. Chong,

If this is not a recurring need, the easiest method would be to create a new
blank table in Access that includes the fieldnames and data types of your
choosing. Then use an append query to append the data from the linked Excel
spreadsheet into your new table. Here is a link that shows you how to create
a variety of action queries:

http://office.microsoft.com/en-us/ac...653171033.aspx


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"mrchong" wrote:

> I have a linked table that has source from an Excel sheet.
>
> I now want it to be converted into normal data table.
>
> How ?

Thanks. Anyway to copy the table heading as well ?

Thanks a million.

"Tom Wickerath" wrote:

> Hi Mr. Chong,
>
> If this is not a recurring need, the easiest method would be to create a new
> blank table in Access that includes the fieldnames and data types of your
> choosing. Then use an append query to append the data from the linked Excel
> spreadsheet into your new table. Here is a link that shows you how to create
> a variety of action queries:
>
> http://office.microsoft.com/en-us/ac...653171033.aspx
>
>
> Tom Wickerath
> Microsoft Access MVP
>
> http://www.access.qbuilt.com/html/ex...tributors.html
> http://www.access.qbuilt.com/html/search.html
> __________________________________________
>
> "mrchong" wrote:
>
> > I have a linked table that has source from an Excel sheet.
> >
> > I now want it to be converted into normal data table.
> >
> > How ?

Hey it works ! Headers get copied as well !!

Thanks !!!
Have a good weekend !

"Tom Wickerath" wrote:

> Hi Mr. Chong,
>
> If this is not a recurring need, the easiest method would be to create a new
> blank table in Access that includes the fieldnames and data types of your
> choosing. Then use an append query to append the data from the linked Excel
> spreadsheet into your new table. Here is a link that shows you how to create
> a variety of action queries:
>
> http://office.microsoft.com/en-us/ac...653171033.aspx
>
>
> Tom Wickerath
> Microsoft Access MVP
>
> http://www.access.qbuilt.com/html/ex...tributors.html
> http://www.access.qbuilt.com/html/search.html
> __________________________________________
>
> "mrchong" wrote:
>
> > I have a linked table that has source from an Excel sheet.
> >
> > I now want it to be converted into normal data table.
> >
> > How ?

I'm not sure what you mean by a table heading. Do you mean some type of
descriptive text that spans one or more cells in one or more rows of an Excel
spreadsheet, typically in the first few rows? If so, the answer is it cannot
be done. Tables in Access may appear similar to worksheets in Excel, but they
are different. There is no support for merging cells in an Access table, like
you can do in Excel.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"mrchong" wrote:

> Thanks. Anyway to copy the table heading as well ?
>
> Thanks a million.