Tables changing data type on the fly??

  • Thread starter Thread starter junk
  • Start date Start date
J

junk

I have a XML file that I import in which is a set format. I don't have
any ability to get the XML file setup changed. All fields are set up
to come into Access as text and do very successfully. However, there
are some of the fields I realy need to be a Number/Double format in
order to properly work with them. Is there any code that could be
written that would change to format of these fields right after import?
I would like to call something from a macro to change these formats.
Any ideas?

Thank you,
Neil
 
Hi Neil,

If it's a set format, how about creating the table in Access with Double
fields where needed (e.g. by importing the XML and changing the field types
manually). Then when you import, click the Options button in the Import XML
dialog and select Append Data to Existing Tables.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application.ExportXML exports dates in the wrong format or the 1899 date if date field is empty 4
Which is the best MBOX Converter Tool different formats conversion? 4
Changing the format of table fields with code 4
Change field data type in table 2
Format Date 2
Parsing Dates at Import 1
error on update table WHERE date comparison 0
Programmatically Change Double Data Type To Long Integer 8

Back
Top