How to convert linked table into real hard data table

[Guest]

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

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

How ?

 

[Guest]

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/access/CH063653171033.aspx


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thanks. Anyway to copy the table heading as well ?

Thanks a million.

 

[Guest]

Hey it works ! Headers get copied as well !!

Thanks !!!
Have a good weekend !

 

[Guest]

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/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________