Half gig xlsx file to access

[vjp2.at]

Pardon intrusion. I have tried external data to get this huge thing inot
access and access chokes. I am considering saving the xlsx as csv then
reading it into access but am afraid I might lose column names. Everything I
do choles for size. The wierd thing is I believe the data was originally in
access but the fools only knew how to use xl. THe reason I posted in this
newsgroup is the other newsgroups were empty so I didn't expect anyone to
read them. Mugh obliged.


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[John W. Vinson]

Pardon intrusion. I have tried external data to get this huge thing inot
access and access chokes. I am considering saving the xlsx as csv then
reading it into access but am afraid I might lose column names. Everything I
do choles for size. The wierd thing is I believe the data was originally in
access but the fools only knew how to use xl. THe reason I posted in this
newsgroup is the other newsgroups were empty so I didn't expect anyone to
read them. Mugh obliged.

I would suggest creating an Access database and creating a table with the
appropriate fieldnames, datatypes and field sizes. Then use External Data to
link to (not import!) the spreadsheet; run an APpend query to migrate the data
into the table.

See my .sig - the newsgroups have not been supported by Microsoft for quite
some time, and I'm one of the few holdouts still answering questions here at
all. Microsoft has its Web forums and there are several third-party web forums
providing support. You may want to post your question in one of them.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[vjp2.at]

Thanks. I saved as CSV and imported into Access 2000 so it would run on all
subsequent versions. Phew. It tool a few hours.


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]