6 replies
by rkuhn040172
by dief05
Can't save the file as delimited - we're dealing with a warehouse, any extra step would make it too difficult, and the save as delimited file would be too complicated. have to import directly from Excel as a 1 step (click a button once) process
by dief05
by mslizny
I do a lot of data conversion, and my
experience with Excel to Access is that if the
entire column in Excel is formatted as text
before you use the import wizard it transfers it
as a text field. It is when you have not
specified a format that it uses "General" which
tries to discern a format from the Excel file.
Also, I know this is automated in a VBA script,
but it is always more useful for me to import
the information into a new table and then use
copy/paste-append to add it to an existing
table so that any errors in format, etc. can be
caught before the data is in the ongoing table.
by dief05
Poster rated this answer.
by dief05
This discussion is closed to new replies.
Trending Software posts
Sort by Trending