Importing Data From Excel Spreadsheet

[SirTom909]

Hello Everyone,

Im importing a table from Excel into Access (Access 97 - Excel 2000)

The data in Excel is formatted as "Custom - "000#" so figures from 1 - 9999
are displayed as 0001 - 9999.

Now once its imported into Access, the table reads as 1,2,3,4 etc and not
0001,0002,0003. The problem started occuring recently, up until then it was
fine.

Any ideas?

Tom

 

[Pieter Wijnen]

Tables store data, not formats
Use Forms & Reports for Formatting

Pieter

 

[SirTom909]

Thanks for your response Pieter,

where do I find Forms and Reports formatting? in Excel I presume?

 

[AnandaSim]

I assume that you are driving Access tables directly rather than
working with Forms and Reports at the moment. If you are directly
viewing the tables, then you should know that Excel and Access do
store the raw data. Each program has ways to display the raw data
differently from what it is stored. So in Excel you say you have a
custom format. After you import the data, you may want to set a custom
format within the table. Go into Design View of the table, then select
the field and look down at the bottom properties panel - there is a
Format box - you can enter the format placeholders there.

Ananda