Import Date Headings

[alish]

Hi All,
I have a question: How do I import an xls file into Access while the xls
files has date as column names? I tried but it did not import the heading
names, instead it put default names: F1, F2 ... . Please halp. THanks.

 

[Stefan Hoffmann]

hi,

I have a question: How do I import an xls file into Access while the xls
files has date as column names? I tried but it did not import the heading
names, instead it put default names: F1, F2 ... . Please halp. THanks.

Use the Import wizard. You can select "First row contains header names"
(or so).


mfG
--> stefan <--

 

[alish]

Thanks. How about importing alpha-numeric values in the columns. In the
column fields i have numbers and letter. but when i import into Access some
of the letter are not there. how do I make it import ALL data? THanks again.

 

[alish]

Stefan, it did not work. Access is still assigning the default column names.

 

[Stefan Hoffmann]

hi,

Stefan, it did not work. Access is still assigning the default column names.

Then your date header columns are using special chars like the dot.
Acces cannot generate a field name from that as these chars are invalid
for field names.


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi,

How about importing alpha-numeric values in the columns. In the
column fields i have numbers and letter. but when i import into Access some
of the letter are not there. how do I make it import ALL data? THanks again.

Access determins the field type by inspecting the first few lines. In
such a case you have to generate a import specification and set the
field type explicitly to Text.

btw, some generic information:

http://office.microsoft.com/en-us/access/HP010950951033.aspx
http://articles.techrepublic.com.com/5100-10878_11-5276622.html

mfG
--> stefan <--

 

[alish]

Stefan, the heading don't have special characters. But, what i did is that i
converted the xls file into csv file and using advance import i was able to
import. Thanks.